April 23, 2008 at 7:41 am
SQL Server 2000 SP4. O/S - Windows 2003. SMTP configured - Yes (for notifications).
We had more than 100 night jobs running everyday and some time they take more time than they should. I am in need of a notification script which just send mails to DBA's that this particular job is running for more than 5 minutes.
After notification, I will kill or keep job alive, depending on situation. But as of now I just need a notification script.
Can some one out there help me get this ASAP, if you have one handy.
Thanks in Adv.
SQL DBA.
April 23, 2008 at 8:34 am
Can some one please post a script, if you have one. Thanks.
SQL DBA.
April 23, 2008 at 10:48 am
I suggest that you search for "long running jobs" on this site. There are several good articles with examples that I used when I was developing a job to alert me about long running jobs.
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply