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.