Export all jobs from a SQL server

To export all jobs from a SQL server.

Open ssms,connect to your sql server.Navigate to SQL Server Agent– jobs.

Click View and select Object Explorer Details or press F7. The Object explorer details window should open on the right. Select all the jobs,right click  select Script job as-Create to — File. Select a location and give any file name and save.

All the jobs would be exported as a single file and you can run that on any other database to restore all the jobs.




About parag waghmare

I am working on the Windows technologies for a long time now. Primarily working as a Service Engineer on System Center products. Right now on System Center 2012 and Windows Server 2012. I have worked extensively on MOM 2005 to SCOM 2007 migrations and SCOM 2007 to SCOM 2012 migrations.
This entry was posted in Microsoft SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s