Scheduler Job Classes
Before creating a job you need to create a scheduler job class. Job inherits basic properties defined for the class.
Creating Scheduler Job Classes
To create a new scheduler job class:
- select the Database | New Object... main menu item;
- select Scheduler Job Class in the Create New Object dialog;
- define scheduler job class properties using the appropriate tabs of Scheduler Job Class Editor.
Hint: To create a new scheduler job class, you can also right-click the Scheduler Job Class node or any object within this node in the DB Explorer tree and select the Scheduler Job Class item from the context menu.
To create a new scheduler job class with the same properties as one of existing scheduler job class has:
- select the Database | Duplicate Object... main menu item;
- follow the instructions of Duplicate Object Wizard.
Alternatively, you can right-click a scheduler job class in the DB Explorer tree and select the Duplicate Scheduler Job Class <scheduler_job_class_name>... context menu item.
Duplicate Object Wizard allows you to select the database to create a new scheduler job class in, and to edit the result SQL statement for creating the scheduler job class.
To edit an existing scheduler job class:
- select the scheduler job class for editing in the DB Explorer tree (type the first letters of the scheduler job class name for quick search);
- right-click the object and select the Edit Scheduler Job Class<scheduler_job_class_name> context menu item, or simply double-click the scheduler job class;
- edit scheduler job class properties using the appropriate tabs of Scheduler Job Class Editor.
Dropping Scheduler Job Classes
To drop a scheduler job class:
- select the scheduler job class to drop in the DB Explorer tree;
- right-click the object and select the Drop Scheduler Job Class <scheduler_job_class_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 job class;
Ctrl+O to edit the selected scheduler job class;
Shift+Del to drop the object from the database.