Backup your SQL Server jobs using PowerShell script

This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance.

It’s an useful job that you have to have running in your environment. It could help you for the following:

  • Backing up your jobs,

  • When migrating from one server to another,

  • When you want to check the history of changes for a job,

  • If you want to keep documentation for your jobs and

The PowerShell script is given below. Save it on a location (.ps1 extension). Then you have to specify the path in the $SavePath variable.

Second step is to create the job. Download the script-code and specify your instance name. Run the script in SSMS studio and you have it. It runs under the sa user. 

That’s all.

Tweet about this on TwitterShare on LinkedInShare on FacebookShare on Google+

Leave a Reply

Your email address will not be published. Required fields are marked *