Sql server agent:Possible date calculation spin for Schedule 43

• vmssanthosh

  SSC Eights!

  Points: 806

  More actions

  March 23, 2010 at 12:31 am

  #156810

  Hi

  When we scan through our sql server agent logs, we found the following warning message, which was strange.

  Can anyone explain me what is it for?

  Date 3/22/2010 6:37:20 PM

  Log SQL Server Agent (Current - 3/22/2010 6:42:00 PM)

  Message

  [191] Warning [2]: Possible date calculation spin for Schedule 43

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 30, 2010 at 3:53 am

  #1200189

  You may try the "workaround" mentioned in this article. Even though it is for SQL 2000, it is worth trying.

  Also could you try changing the start date of the job to a recent date (may be today), if the existing value is too old?

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga