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: http://support.microsoft.com/kb/2640027
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.