トップ回答者

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?

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

すべての返信

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

The job confirmation is that it succeeds. However when the job runs, it may have "completed with errors" - is there a way to find that kind of error detail, and more importantly, is it possible to send notifications when that occurs (success/completed, but
with errors)?

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.