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.

Comments (1)

  1. Gazaoui says:

    Bonjour

    C’est au sujet des connerie il arret ces abuse Disable USB Storage Devices Fix it Live!