question

Bugmesh avatar image
Bugmesh asked

Corrupt Job Schedule

In SQL Server 2000, is possible for a Job Schedule to become Corrupt? and if so, how does that happen? The observed behavior, was an error being thrown that the number 75 was not a proper MIN or MAX and the schedule would not open for editing. (The job has been running on this schedule has been running for 3 weeks) I removed the the schedule and created a new one successfully. I also did integrity checks on MSDB, MASTER, and the user databases and no errors were reported. This question is more for satisfying my curiosity than anything else. I have been doing DBA work for 12+ years and I can honestly say, I have never seen this before. Very much appreciate any input on the topic To all the Veterans out there 'Thank You" and Happy Veterans Day!, Happy Remembrance Day!
jobcorruption
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
Yeah, I've seen that kind of thing happen once or twice. It's not like a full blown database corruption issue, but something within one of the tables in msdb gets corrupted.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.