The job can be executed manually, by scheduler or by a monitor alert. When the same job is triggered simultaneously from several sources, it is executed only once. For example, if the backup job was triggered by the alert and while it is still running, the scheduler process attempts to start it as well, the second execution command will be ignored by Sentinel.
To initiate a job's execution from the SSJE GUI, select a job in the Jobs folder of the Object Explorer and choose Execute from the shortcut menu. You will see the progress of the execution in the Properties panel of this job. The job is executed by Sentinel in the background so that you can close SSJE UI at any time - it will not cancel the job's execution process. Only stopping of the Sentinel service will cancel a running job. To explicitly cancel a running job, select this job in the Jobs folder and choose Kill from the shortcut menu. It might take longer to cancel the SQL Script job, because it requires interruption of the process on the database server.
You can see an entire job execution history any time when you open SSJE UI, by selecting Properties from the job's shortcut menu and switching to History tab located at the bottom of the Job Properties panel. The Last Execution tab contains information about the last job Sentinel executed.
You can schedule a job execution using Schedule tab of the Job Editor's dialog box. Use either Schedule or Edit job's shortcut menus to open this dialog box.
To enable the scheduled job execution, check Enable Schedule checkbox and press OK. The job's icon in the Jobs folder should be changed to 'alarm clock' icon. The job will be scheduled on the Sentinel server and will be executed even when the Server Studio UI is not opened.
To disable the scheduled job execution, uncheck Enable Schedule checkbox and press OK. The job will be removed from the Sentinel server's list of jobs. The schedule parameters are not reset so that you can re-activate the same schedule later by checking the Enable Schedule checkbox.
Job Execution in Response to Alert Event
To execute a job in response to a monitor's alert event:
1. Select the monitor in the Object Explorer's Automation -> Monitors node.
2. Choose open from the shortcut menu. The monitor document will be opened.
3. In the monitor document press Alerts button or choose Monitor -> Alerts top-level menu. The Alerts editor will be opened.
4. Select required alert condition in the Alerts grid, check Execute Job checkbox in the Alert Actions panel
5. Choose created and tested job from the Jobs dropdown list.
Tip Always execute the job from the SSJE UI before assigning it as an alert action to make sure that it performs as designed.