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 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply