Microsoft Fix it BLOG

Automated solutions that are easy, intuitive, and available when and where you need them. Browse for solutions or sign in and post a comment.

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

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

  • Comments 1
  • Likes

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
  • Bonjour

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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment