Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI'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 erro r in the error log: [192] Date calculation spin detected for Schedule 18 a nd 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!
Post Follow-up to this messageHi 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.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread