Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
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 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!

Report this thread to moderator Post Follow-up to this message
Old Post
StephenRay
04-06-06 04:23 PM


RE: NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
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.


Report this thread to moderator Post Follow-up to this message
Old Post
Wei Lu
04-07-06 08:24 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 08:13 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006