How to Run SQL Server Maintenance Jobs

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”. Add SQL Server maintenance jobIn the window that opened you will find five simple things that you need to set up to start your SQL Server maintenance job.

  1. Computer

    Firstly, choose the computer that your are going to work withSQL Server maintenance job point 1

  2. SQL Server

    Secondly, check SQL Server connection. If you need to connect to another SQL Server you can do it from SqlBak App. SQL Server maintenance job point 2

  3. Maintenance scripts

    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.SQL Server maintenance job point 3

  4. Schedule maintenance

    You can turn it on or turn it off. When you turn it on you can set the schedule when scripts should be launched.SQL Server maintenance job point 4

  5. 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. SQL Server maintenance job point 5

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.

Leave a Reply

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