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 |
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2004-01-09 : 17:39:16
|
Hi, I had a job which ran forever and hosed all other jobs later. None of the alerts for the job paged me because the status of the job was neither complete, success or failure. Is there a way to alert you if a job exceeds certain time? I figured out sql statement to put in an stored proc but checking if there is an easy way using EM tool?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-09 : 17:41:24
|
No such tool exists. Your stored proc will need to be used.Tara |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2004-01-09 : 17:47:09
|
Ok, Just wanted to try before I go the long way ;-)Thank You.Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
|
|