Restoring Jobs in SQL 2000
Posted on 2009-04-02
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 the entire server done with Backup Exec 11d. Do I need to restore the entire server or is there another way to find and restore just the jobs from 2000 to our new 2005?