Does anyone know where the jobs are stored in SQL 2000? The reason I’m asking is because we recently replaced a server and installed SQL 2005 on it. Apparently, the old server had some SQL jobs on it that I need to recover (not backup jobs or shrink jobs, but other types).
I have a full backup of all of the databases that were on that server, but those .bak files don’t contain any of the jobs. I do have an image that I can mount of the entire drive that had SQL installed, so I’m hoping that those jobs are stored somewhere that I can just import onto the new server.
