Post reply

Notification if a job runs longer then ...

  • May 20, 2004 at 4:57 am

    #82897

    Hi!

    What is the best way to setup notification for administrator if a particular every minute job runs longer then, lets say 10 seconds?

    Thanks.

     

     

  • May 20, 2004 at 6:17 am

    #507104

    I had project with similar request about two years ago. The solution was to use WshShell.Exec method to run sql job, check Status, CDO mail if excess a limitation.

  • May 20, 2004 at 7:07 am

    #507113

    Could you place some code here on how to do this?

  • May 20, 2004 at 7:21 am

    #507120

    I'm not sure you can tell on the 10sec mark, but you could setup a 2nd job to run and check the output from sp_help_job for your specific job having completed.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply