Sunday, December 8, 2013

SQL job related

SQL Server Agent Job Schedule Reporting Last Updated: 2017-08-31
(downloadable scripts exist at the end of article)

SQL Job seemed to be started, as indicated by "Last Run Status (Start Date)" column, but nothing (neither Successful or Failed) found on "Job History":
The job DID have started but interrupted before it got finished (for example, due to scheduled server shutdown)
Solution: schedule the job to start earlier

No comments:

Post a Comment