Notification if job completes with errors


  • 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?
    2011年12月23日 14:42