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 |
|
Starlet_GT
Yak Posting Veteran
81 Posts |
 Posted - 2011-08-04 : 01:10:06
|
| Hi,I am facing a issue which I need to know how to overcome. I got few jobs which are scheduled to run after every one hour, but unfortunately jobs didn't completed and are pretended to be running when we check the job status. Although I have developed a mechanism through which if a job failed it intimate me but in this case when job is still running I didn’t know about the status until someone tells me that they are not getting required data through system. And then I have to stop it forcefully and re-run it. It happened once in a month but it is unusual.I want a query or something through which if a job keeps on running after 5 hours it should be automatically killed. Please help. |
|
|
|
|
|
Stuck Job in Sql server agent 2008