Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2007-01-03 : 23:19:56
|
HI ALL,I have a SQL job that runs twice in a day. Nowadays many time the job was continuously running (not stopping until manually stop) and thats why the goal of that job is not satisfied. Plz tell me why this is happening.Urgent.......ThanksNjoy Life  |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-03 : 23:58:45
|
| can be many things. what is the job doing? what else is happening on server when job runs. can use profiler to check. also perfmon for server performance. likely trying to modify data already locked by front end application. if job drops and recreates objects, and this is a busy system, front end application may put shared lock on object and your job waits forever. too many possibilites without more information to give a decent answer. |
 |
|
|
|
|
|
SQL job takes more time