SQL Agent Schedule Problem

[SajidAttar]

Hi Guys,

Below is the link of the question posted on MSDN SQL Forum. Question posted is about SQL Agents behaviour when changed system calendar date to backward.

I could not get proper forum for SQL Server Agent related queries, I am sure could get direction from this forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3653772&SiteID=1

Any suggestions???

Regards,


"Dream not what makes your sleep a pleasure, but what makes you work
hard to achieve it and forget your sleep (untill you achieve it)." -- SJD

 

[ousoonerjoe]

I have had issues in the past with SQL Server 2000 getting out of sync with the domain controller. Once the times were far enough apart, SQL connections would stop connecting. As soon as we re-synced the time to the domain, everything went back to normal. If the client got too far out of sync with the servers, they would begin to get connection errors. We never found a true fix for this. Other than making sure the servers and clients were synced up. At times it would take a few days for the error to clear itself out.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.