Job failures are automatically logged in sysjobstepslogs table in the msdb database.
You can set the notification like email to a id or group on failure in job for this and further enable the Windows logging to check the error details.
Refer below links for more details
http://ift.tt/1gPjfVR
http://ift.tt/1h3uXvx
http://ift.tt/1h3uWHL
Please click the Mark as answer button and vote as helpful if this reply solves your problem
No comments:
Post a Comment