PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Running a job on the target servers

1. Open the SSMS, and then select View > Object Explorer.
2. In the Object Explorer, expand SQL Server Agent, right-click Jobs, and then select New job.
3. On the Job Properties window:
   1. On the General page, type the appropriate information in the Name, Owner, and Description fields.
   2. On the Steps page, click New to create a step.
   3. In the Job Step Properties window, complete the following steps:
      1. On the General page, specify the following fields:
         • Step name: Type a name for the job step.
         • Type: Select Operating system (CmdExec).
         • Run as: According to your configuration, select either proxy or SQL Server Agent Service Account.
         • Process execute exit code of a successful command: Type the process success exit code.
         • Command: Specify the required command.

           Perform backups with the Microsoft app agent for Application Direct SSMS plug-in provides information about how to generate the command.

           The generated command does not have a full path to the binary. When you specify the generated command in this field, you must add the full path to the binary. If the binary path contains spaces, specify the path in the quotes.

           For example:

           "C:\Program Files\DPSAPPS\MSAPPAGENT\bin\ddbmsqlsv.exe" -D9 -c NMMDB154.nmmdev.com -l full -a "NSR_DFA_SI_DD_HOST=10.31.192.14" -a "NSR_DFA_SI_DD_USER=ddbma" -a "NSR_DFA_SI_DEVICE_PATH=/ddbma-sqlagent2" "MSSQL:master"

      2. On the Advanced page, specify the following fields:
         • On success action: Select whether to proceed to the next job step or quit the current job step and report success, after the current job step succeeds.
         • Specify the other fields according to your requirements.
         • Click OK.
   4. On the Schedules page, click New to schedule a job.
   5. In the Job Schedule Properties window, specify appropriate information in the corresponding fields, and then click OK.
   6. On the Alerts page, click Add to create an alert that will perform a job when a certain event occurs.
   7. In the New Alert window:
      1. On the General page, specify the following fields.
         • Name: Type a name for the alert.
         • Type: Select the type of the event.
         • Specify the appropriate information in the other fields.
      2. On the Response page, specify the following fields:
         • Notify operators: Select this option to send a message to the operators about the job step status.
         • New Operator: Click this button to add an operator to the Operator list.
      3. On the Options page, configure a method, such as E-mail, Pager, or Net Send, to notify operators about the status of the job step.
      4. On the Notifications page, under Actions to perform when the job completes, select the appropriate notification methods to notify operators about the status of the job step.
      5. On the Targets page, from the Target multiple servers list, select the target servers.
   8. Click OK.