patternsqlMinor
Save multiple SQL jobs in single files
Viewed 0 times
sqlsavejobssinglefilesmultiple
Problem
I'm using SQL Server 2005 and I need to save every SQL agent job in single 'create in' *.sql files. The problem is that I got about 20 SQL Server with 15 (up to 51) SQL jobs.
How can I export these jobs easy in single files?
If I mark all jobs they will be saved in a single file. It would take to long to manually export every single job to a file.
Did someone have an idea?
How can I export these jobs easy in single files?
If I mark all jobs they will be saved in a single file. It would take to long to manually export every single job to a file.
Did someone have an idea?
Solution
There are two possible ways
II. Select All Jobs (Shift + Mouse Click) -> Right Click -> Script Job as
- Automatically create scripts for all SQL Server Jobs
- I. Open Object Details
II. Select All Jobs (Shift + Mouse Click) -> Right Click -> Script Job as
Context
StackExchange Database Administrators Q#89349, answer score: 8
Revisions (0)
No revisions yet.