Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How to script jobs

2 Posts 2 Posters 0 Views 1 Watching

C Offline
C Offline
cdpace

wrote on last edited by

#1

Hello guys, Anyone knows how to script SQL jobs from a sql server database so that i can script them back into another database? I am using Quest Toad For sql server to view the sql jobs on the server. Regards, Christian Pace
W 1 Reply Last reply

0
C cdpace

Hello guys, Anyone knows how to script SQL jobs from a sql server database so that i can script them back into another database? I am using Quest Toad For sql server to view the sql jobs on the server. Regards, Christian Pace
W Offline
W Offline
WoutL

wrote on last edited by

#2

For SQL2000 using SQL Server Enterprise Manager: Right-click on the job, choose for all tasks/Generate SQL Script...

Wout Louwers
1 Reply Last reply

0

Log in to reply