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 |
|
DLTaylor
Posting Yak Master
136 Posts |
 Posted - 2010-11-09 : 05:05:10
|
| I am using SQL 2005 sp3.I have number of jobs on a server that run every 20 mins and complete usually within 3 to 5 mins.On occasions one will get stuck as ‘executing’ which effectively means that particular job would not run again until I intervened.For some reality… I have just found a Job running for 16hours – that usually lasts 3 minutes!! ;-(Is there a way to set an email \alerts when ‘any server job’ running lasts longer than e.g. 30 mins?Ideally I would have one Job \ alert looking at each server – as opposed to adding this alert to each job individually.I’d be interested to see if anyone could advise on an effective way of doing this.Thanks |
|
|
|
|
|
create an alert when Job lasts over given time