SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

MS SQL Maestro online Help

Scheduling administrative jobs means defining the condition(s) that cause the job to begin running. Using these server objects you can schedule any type of job. The same job schedule can be used by more than one job. A user can attach and detach schedules from jobs. The object is available in Microsoft SQL server 2005 or higher.

Only one instance of the job can be run at a certain moment. If you try to run a job manually while it is running as scheduled, SQL Server Agent refuses the request.

To prevent a scheduled job from running, you should either disable the schedule using the corresponding option of the Schedule Editor dialog window, or disable the job using Job Editor, drop the schedule using the Drop Schedule item of the popup menu in the Available Schedules field of Job Editor, or stop the SQLSERVERAGENT service on the server. When a job schedule is not enabled, the schedule is not enabled for any job that uses the schedule.

You must explicitly re-enable a schedule that has been disabled.

Note: Jobs can only run when the SQLSERVERAGENT service is currently running on the server.

New schedules are created within Schedule Editor. In order to open this editor you should either

•	select the Schedules list or any object from that list and then use the Create New Schedule item from the popup menu

•	open the server in Server Editor and the Schedules tab there and press Insert or select the Create New Schedule item from the popup menu (Alternatively, use the corresponding link of the Navigation Bar).

Schedules are edited within Schedule Editor. In order to open the editor you should either

•	select the schedule for editing in the explorer tree (type the first letters of the schedule name for quick search);

•	select the Edit Schedule item from the popup menu

•	open the server in Server Editor and the Schedules tab there;

•	select the schedule to edit;

•	press the Enter key or select the Edit Schedule item from the popup menu (alternatively, you can use the corresponding link of the Navigation Bar).

To drop the existing schedule:

•	select the schedule to drop in the explorer tree;

•	select the Drop Schedule item from the popup menu

•	open the server in Server Editor and the Schedules tab there;

•	select the schedule to drop;

•	press the Delete key or select the Drop Schedule item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.