When you open the Add Job wizard, the first section of this wizard requires you to fill general information for the job. You can find the following fields:

Take into account that you have to specify at least the instance, name, and category in order to create the job. 

How does the Maintenance Mode work?

While SQL Enterprise Job Manager is running the background collecting Service periodically, for every instance it checks if maintenance mode is enabled, if enabled then it checks if the current time falls in between a schedule window for the instance. If it falls in the schedule window then SQL Enterprise Job Manager enables the maintenance mode and sets in_maintenance to 1 in the instance table. In the same way, whenever SQL Enterprise Job Manager is collecting statistics for a given instance, it checks if the instance is in maintenance mode and if the schedule window is expired 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:

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.

Keep in mind the Job Wizard does not display information from SQL Server instances that cannot be reached.

Take into account 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: StepsSchedules, AlertsNotifications,Targets .



 |   |  |  |  |