Save multiple SQL jobs in single files 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?
There are two possible ways
1.  Automatically create scripts for all SQL Server Jobs 


I. Open Object Details


 

II. Select All Jobs (Shift + Mouse Click) -> Right Click -> Script Job as