Now you can run regular SQL Server maintenance jobs with the help of SqlBak. This feature can be useful if you regularly need to make some changes to your database. All these changes can be made by adding any SQL Server command (using T-SQL) or adding Windows batch (*.cmd, *.bat).
How to Create SQL Server Maintenance Job.
Now let’s create a new SQL Serve maintenance job, for that go to “Dashboard” page and click “Add new job” button, then choose “Add maintenance job”. In the window that opened you will find five simple things that you need to set up to start your SQL Server maintenance job.
Firstly, choose the computer that your are going to work with
Secondly, check SQL Server connection. If you need to connect to another SQL Server you can do it from SqlBak App.
Then you need to add either SQL script or Windows batch. There are two ways to add SQL script. Use “Add from template” and select those that you need. If you can not find the required script, simply type it in the box below.
To add Windows batch (*.cmd, *.bat) click on the following button and add it to the box. You can allow time during which the script must be performed, otherwise, it will be marked as “Failed”. You can add any number of different scripts in different order. Moreover, you can delete some if you do not need them anymore.
You can turn it on or turn it off. When you turn it on you can set the schedule when scripts should be launched.
Send email confirmation
If you prefer to receive an email confirmation, then turn it on. Also, you can set up to receive confirmation when the job is successful or when the job failed. In addition, you can receive them together or separately to different e-mail addresses. Please note that you can enter multiple emails separated by comma.
Now your job is ready, the one thing you need to do to save and run SQL Server maintenance job is to press “Create” button.