When opening the Add Job wizard, requires filling in the general information for the job. You can find the following fields:
Maintenance mode - Enable this option to add a maintenance window in your instance for job maintenance. For more information, please see below.
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. |
Consider that to create a job you have to specify at least the instance, name, and category.
While SQL Enterprise Job Manager is running, the background collecting Service periodically checks:
There are more additional options to enhance the behavior of 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, network interruption, or performance reasons if the collection is delayed then the Maintenance Mode will also start late.
Keep in mind the Job Wizard does not display information from SQL Server instances that cannot be reached. |
Consider that Read-only users cannot add new jobs from SQL Enterprise Job Manager to their monitored instances. |
Keep in mind that characters such as &, +, ', ", are not accepted when editing the job name. |
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.
| | | | | | | |