We have a Server that has sql server 2000 installed on it. There are about 36 jobs with different schedules and different jobs backup to different disk drives and there are also jobs that do other db maintenance things like re-indexing etc.
I have got a second server with the same disk drive names as server one, now I want to create on this server all the jobs that we have on the first server.
Is there a way to script all the jobs with a command or a utility script from server one and then run it on server two and create all the jobs on server two. Doing one by one would be very painful. I don't see anything in Enterprise manager that seems to do this