none
Notification if job completes with errors

    Question

  • I have a job that runs a stored procedure to update SQL tables; it then deletes and updates tables in Access. I have found that sometimes this job seems to "fail" somewhere in executing (end result is that Access tables are not updated), yet the notification that I receive indicates "the job succeeded." Is there a way to set up notifications if the job completes, but there are errors in any of the steps?
    Friday, December 23, 2011 2:42 PM

Answers

All replies