June 4, 2009 at 11:49 pm
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
Thanks,
Bharat.
June 5, 2009 at 2:07 am
Right click Jobs, click All Tasks, Generate SQL Script.
That will script all the jobs on the server.
June 5, 2009 at 2:28 am
when you script out the jobs see to it that your tsql job steps dont have "GO" batch breaker.
If its there the script will give error while executing.
It seams you should replace "Go" with other batch breakers not sure which one.
Tanx 😀
June 5, 2009 at 10:09 am
Thanks!
Yes three are several 'GO' in the individual jobs. I guess it would be ok to script them first and then deal with the 'GO' separators within the jobs. There are 'GO' seperators that separate the individual jobs I see in this all jobs script I generated.
BV
March 25, 2011 at 2:33 pm
There is no ALL Task option when you right click JOBS in SQL 2000. Am i missing something? Thanks!
November 9, 2014 at 3:24 pm
Use Enterprise Manager in SQL2000. All tasks not available via Management Studio for SQL2000.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply