Need help dear SQL Gurus,

There was a time wherein our Domain Controller for some reason changed
time from the current day (Dec. 15, 2007) to 02/11/2008, there was also
a moment that it became 3/02/2008. The problem is during this period,
most of the automated jobs were running and when the time issue was
resolved, none of the jobs ran anymore because their next run date is
scheduled to be on 2/11/2008. We don't get notification anymore because
MOM is currently being built so for now, we are really vulnerable and
doesn't have visibility of what failed. It just happen, that I created
a job that should run hourly but for one of the SQL servers (one which
has been affected by the time issue), this job is not running anymore
and I was able to rebuild it. Unfortunately, it was only until now that
I notice that the back-up, optimization and those sort of maintenance
were not running (I really seldom open the Job Monitor). Yeah yeah, I
know, I need some spanking and believe me, I am already pulling my hairs
right now.


Okay, now, I wanted to set the next_run_date to tomorrow but it's not
taking effect. There were 4 jobs that were changed but the others
persists. I restarted the SQL Server Agent, but the next run date
reverts back to the future date.



How can I apply the changes so that the jobs will run again (and yeah,
not wait for 2008) without recreating the jobs?



Thanks a lot for your help!





__________________________________________



Mary Ann Salas

Production DBA


mailgate2.profitline.com made the following annotations---------------------------------------------------------------------The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
---------------------------------------------------------------------

MS Sql Server LazyDBA home page