FIX: SQL Server Agent job fails if you set the job schedule type as "Start automatically when SQL Server Agent starts" in SQL Server 2008 SP2

KB Article:


Consider the following scenario:

  • You install Cumulative Update 2 for Microsoft SQL Server 2008 Service Pack 2 (SP2) or a later version of the cumulative update package on a computer.
  • You create a SQL Server Agent job on a user database and set the schedule type as Start automatically when SQL Server Agent starts.
  • You restart the SQL Server service.

In this scenario, the SQL Server Agent job fails.