WMI Event Alert: This alert is fired when a specific Windows Management Instrumentation (WMI) event occursĪpexSQL Job allows the user to create all three mentioned SQL Server Agent Alert types:Įach alert type has its own configuration settings.SQL Server Performance Condition Alert: This alert is fired when a specific performance counter exceeds, equals or falls below a predefined threshold value.SQL Server Event Alert: This alert is fired when an event with a specific error number or error severity level occurs.There are three types of alerts that can be created in the SQL Server Agents: These can be accessed by clicking on the Alerts tab in the New job wizard.Ĭlick on the Add button to create a new alert: Once the job schedule is set, the next focus of job creation is setting job alerts. Once the new schedule for the job is created, it is shown under the schedules list where it can be edited or deleted at any time by clicking on the Edit or Delete buttons respectively: The Active checkbox must be marked in order for the selected schedule to become active upon its creation.
Chosen schedule parameters can be seen in the Summary section: Choose the job recurrences and job start and end dates. If the Time is selected as the schedule type, set the desired job frequency in the Frequency area. Selection of either of those two directly affects the Summary: One out of the two types of event can be selected in that case the job could start when the SQL Server Agent starts or when the CPU is in idle state. The Event schedule type indicates that the job will be triggered as a response to a specific event. After entering a descriptive name for the schedule, select a type of schedule – either Event or Time. The New Job schedule window allows you to specify when and how frequently the job will be executed. Let’s now click on the New button to open the New job schedule window and go through its creation steps: Here, we could create a new, custom schedule or select an already-created one by clicking on the Pick drop-down button: To create a new schedule for a specific job, click on the Schedules tab on the left side of the New job wizard: The next step now would be to set a schedule time for our job, which will specify when and how frequently the job will be executed. The created job step will appear in the steps list, where can be further edited, deleted and moved up or down on the list: To create more job steps, click on the New button again and repeat the same steps. You may also choose where to write the output of the step execution: In case of failure, specify the number of retries and elapsed time between retries. Here, control the action that will be taken when the step is either completed successfully or fails. Still within the New Job wizard, go to the Advanced tab to further tune the job step settings. Additionally, there is the option to load a prepared script directly from its folder: Choose the database on which to perform this job step and write the command directly in the Command box. Also, select a step type among the twelve different types of tasks offered in the drop-down list. We recommend using a name that describes the step’s functionality. In the New job step window, provide a name for the step. Here add a new step to the job by clicking on the New button. Move down to the Steps tab of the New Job wizard. Additionally, choose a category for the job: Provide a name for the job, select its owner, and optionally provide a meaningful description of its functionality. In the New Job wizard, under the General tab, choose the preferred SQL Server where you want to create the job. Let’s create a new job by clicking on the New button under the Jobs tab.
To start it, click on the Start button in the Home tab: A yellow triangle on the icon indicates the service is not running. Now, check to see if its Agent service is up and running. To add more SQL Servers, click on the Add button again and repeat the same steps. Then, select a custom folder for the newly added SQL Server or add it to an existing one: To begin, let’s connect to a SQL Server instance by clicking on the Add button in the Home tab and selecting the instance from the Serverdrop down list.Ĭhoose the authentication type, enter the credentials and click OK:
In this video, we’ll demonstrate some of its features and capabilities. Its wide range of features allows users to manage SQL Server schedules, define and manage SQL Server job alerts, view detailed job history, monitor SQL Server Agent logs and export job details to various file formats. ApexSQL Job is a powerful application used to manage and automate SQL Server Agent jobs. Hello, and welcome to this introduction of ApexSQL Job. In this article, we will take an overview of some main features in ApexSQL Job.