Backup of Job's List only

Goal:
Reuse the SQL server agent job's list.

Problem:
The list contains alot of jobs and I need to reuse the job's list in a another time without recreate it. Is there a possibility to make a backup of job's list only?

I don't prefer recreate it by drop and click.

Information:
*The list contains a lot of jobs.

November 30th, 2013 3:55pm

Not sure you mean by reuse, but you can use " EXEC MSDB.DBO.sp_HELP_JOB" to list information about your jobs and status.

http://technet.microsoft.com/en-us/library/ms186722.aspx

You can script your jobs by the following

1. Select "View | Object Explorer  Details"

2. Ctrl + A (Select All)

3. right-click and "script job as | Create to"

Free Windows Admin Tool Kit Click here and download it now
November 30th, 2013 4:23pm

Goal:
Reuse the SQL server agent job's list.

Problem:
The list contains alot of jobs and I need to reuse the job's list in a another time without recreate it. Is there a possibility to make a backup of job's list only?

I don't prefer recreate it by drop and click.

Information:
*The list contains a lot of jobs.

Hello,

Please see how this can be achieved through SSIS

http://technet.microsoft.com/en-us/library/ms137568.aspx

December 1st, 2013 1:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics