It is very easy to move (recreate) the sql agent job that you want to export to another instance of SQL server
- Highlight the job you want o export
- Right click
- Choose Scrip Job as CREATE TO
The script is created and you can run that in the new instance that will create the job.
To move multiple jobs
You can also script multiple jobs to a single file. In SSMS
Click on Jobs,
hit F7 to get the 'Object Explorer Details' tab.
Highlight the jobs you want,
Script job as...
No comments:
Post a Comment