I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!
Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default...b;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment