Notofication script !!!

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  April 23, 2008 at 7:41 am

  #71840

  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.

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  April 23, 2008 at 7:42 am

  #806051

  Please read other post. Some how this got duplicated. My apologies.

  SQL DBA.