Page History
When you open opening the Add Job wizard, the first section of this wizard requires you to fill requires filling in the general information for the job. You can find the following fields:
- Add/remove Instances - click this option to select Select the instances where you want to create the job. Click your Choose the instances in the Available Instances column and click > to add them to the Selected instances section. You can also use >> to select all available instances.
- Name - type Type a name that better describes your job or a name that it is easier for you to identify the job with.
- Owner - select Select the owner of this Job. SQL Enterprise Job Manager allows you to select the owner from a list of available users obtained from the instance you have selected before.
- Category - select Select a category for your job . For example, you can choose from: (Data Collector, Log Shipping, REPL-Alert Response, or others).
- Enable - define Define if you want your job enabled or disabled. You can create jobs and enable them later. When the job is disabled, the job does not run in response to a schedule or alert.
Maintenance mode - enable Enable this option to add a maintenance window in your instance for a job maintenance. For more information, please see below.
Note Jobs created in SQL Server Management Studio (SSMS) do not have the option of selecting jobs for Maintenance Mode; however, you can apply it via Edit Job in the SQL Enterprise Job Manager Web Console. - Description - write Write a short description of your job to help you identify its objectives, steps, and any other relevant information.
Take into account that Consider that to create a job you have to specify at least the instance, name, and category in order to create the job.
| Anchor | ||||
|---|---|---|---|---|
|
While SQL Enterprise Job Manager is running, the background collecting Service periodically , checks:
- That the maintenance mode is enabled for every instance. If it
...
- is
...
- enabled then it checks
...
- whether the current time falls in between a
...
- scheduled window
...
- . If it
...
- does then SQL Enterprise Job Manager enables the maintenance mode and sets in_maintenance to 1 in the instance table.
...
- Whether the instance is in maintenance mode and
...
- the schedule window is expired. If both do then it stops the maintenance mode and sets the in_maintenance column to 0 in the instance table.
There are more additional options to enhance the behavior of maintenance mode:
- Disable alerts during maintenance mode - when this selected, SQL Enterprise Job Manager skips new alerts raised in the maintenance mode window.
- Disable non-maintenance jobs during maintenance - when creating a Job via SQL Enterprise Job Manager we have an option to mark a job as in maintenance mode. If this option is selected then all All the jobs which are not marked as maintenance mode are disabled at the start beginning of maintenance mode and are re-enabled at the end of the maintenance mode.
- Stop maintenance jobs that run past the maintenance window - if this option is selected, then SQL Enterprise Job Manager sends a trigger to stop the maintenance jobs which are running even after the end of the maintenance mode.
The Maintenance Mode start and stop time might vary because the SQL Enterprise Job Manager Collection Service needs to run at a given time. Because of any delay or , network interruption, or performance reasons if the collection is delayed then the Maintenance Mode will also start late.
| Note |
|---|
Keep in mind the Job Wizard does not display information from SQL Server instances that cannot be reached. |
| Warning |
|---|
Take into account Consider that Read-only users cannot add new jobs from SQL Enterprise Job Manager to their monitored instances. |
...
After making your settings in the General section of this wizard, you can finish and save the job, or you can go to any of the following sections: Steps, Schedules, Alerts, Notifications, and Targets.