Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2002-10-29 : 18:25:55
|
| I've got a weird one. We just discovered that one of our maintenance plans hasn't been running for a few days (bad news, it was the backup; good news, it was for a fairly static DB). The job to run it was just gone. Poof!Just editing the maintenance plan recreated the job properly.I'm quite certain that I didn't delete the job (didn't even look at the jobs recently until I noticed it was missing), and I'm the only one with sa access.Anyone seen this? I'm willing to accept "human error," since 99 times out of 100 that's the case when I think SQL server has done something weird, but I really can't see how this could have happened accidentally.Cheers-b |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
|
|
|
Anyone seen a job for m/plan disappear?