|
Home > Archive > MS SQL Server > April 2006 > NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
|
|
| StephenRay 2006-04-06, 11:23 am |
| 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!
| |
| Wei Lu 2006-04-07, 3:24 am |
| 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/defaul...kb;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.
|
|
|
|
|