Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Schedules

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

or

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

or

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

or

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.

 



Prev Return to chapter overview Next