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.
No comments:
Post a Comment