Repeat Failed Job Notifications

  • I have a bunch of jobs setup to notify an operator on failure. What I am looking for is the notification to continue to alert the operator until he responds. Does anyone know of a way to have SQL do this or any software that facilitates this? Thanks for your help.

  • One way to do this would be to collect the job failure by trapping it in a on failure step, use that step to insert into a table, and have another job check in that table to see if you have any new records, if the job finds a record with a flag = 0 than send an email to the operator, have the job run every n minutes and send the mail. When the operator finally responds, have some mechanism to update the flag in the alert table. You then have a history of alerts and response times.

    Andrew

Viewing 2 posts - 1 through 1 (of 1 total)

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