how to check sql server agent job for errors code example
Example: how to check sql server agent job history
-In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-Expand SQL Server Agent, and then expand Jobs.
-Right-click a job, and then click View History.
-In the Log File Viewer, view the job history.
-To update the job history, click Refresh.