All my scheduled jobs are gone. Sort of.

[northstardave]

I just put on Hotfix 37 (resolves a Dr. Watson problem) & after the reboot all my jobs are gone, both scheduled and otherwise. The history is still there & if I try to re-create the job I get told that there is already a job with that name. I've seen pointers to install SP1 but I've had that one on forever. I'm pretty sure this is database corruption so I ran all the check/rebuild/etc tools that I could find & nothing has worked yet. KB & newsgroups have shed very little light on this. One guy suggested a procedure to determine which row in the DB is corrupt & then fix it by hand but I'm kind of afraid to go hacking the DB.

Any suggestions would be appreciated. I'm going to open a case w/Veritas when I go back in to work in the morning but if this is a known problem w/a known solution I would like to know in advance.

 

[joepc]

What version are you using. There are options you can set so scheduled jobs aren't displayed on the job monitor.

 

[northstardave]

9.1 w/sp1.

Not only are they not in the Monitor but they aren't showing up in the Job Setup either. If I try to re-create them it complains of duplicates, though, so I know something is in there.

 

[Scanner]

Can you restore the BE database from a previous backup?