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

INTRODUCTION

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.