EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Scheduler Window Groups


Scheduler window groups provide an easy way to schedule jobs that must run during multiple time periods throughout the day, week, and so on.

 

 

Creating Scheduler Window Groups

 

To create a new scheduler window group:

Hint: To create a new scheduler window group, you can also right-click the Scheduler Window Group node or any object within this node in the DB Explorer tree and select the Scheduler Window Group item from the context menu.

 

To create a new scheduler window group with the same properties as one of existing scheduler window group has:

Alternatively, you can right-click a scheduler window group in the DB Explorer tree and select the Duplicate Scheduler Window Group <scheduler_window_group_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new scheduler window group in, and to edit the result SQL statement for creating the scheduler window group.

 

 

Editing Scheduler Window Groups

 

To edit an existing scheduler window group:

  • select the scheduler window group for editing in the DB Explorer tree (type the first letters of the scheduler window group name for quick search);
  • right-click the object and select the Edit Scheduler Window Group<scheduler_window_group_name> context menu item, or simply double-click the scheduler window group;
  • edit scheduler window group properties using the appropriate tabs of Scheduler Window Group Editor.

 

Dropping Scheduler Window Groups

 

To drop a scheduler window group:

  • select the scheduler window group to drop in the DB Explorer tree;
  • right-click the object and select the Drop Scheduler Window Group <scheduler_window_group_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new scheduler window group;

Ctrl+O to edit the selected scheduler window group;

Shift+Del to drop the object from the database.