Supported Types of Database Jobs
Database jobs allow you to perform certain tasks in the database on a schedule.
Database Tour can work with Cron jobs in PostgreSQL database and with jobs created using DBMS_SCHEDULER and DBMS_JOBS packages in Oracle database.
Notes
- The current database user must have the corresponding permissions to work with these objects.
- In PostgreSQL, to work with Cron jobs, the pg_cron extension must be installed.
- In Oracle, DBMS_JOBS package is obsolete. It is recommended to use DBMS_SCHEDULER instead.
- Most of the information below applies to PostgreSQL pg_cron jobs and Oracle DBMS_SCHEDULER jobs.
- There is a separate topic with much more details about PostgreSQL and Cron.
To work with database jobs, use the corresponding tabs of the Object Browser.
Creating Database Jobs
To create a database job from scratch, click New button 
of the Object Browser. The new SQL editor will be opened with the skeleton of the database job SQL code. Complete the code and click Execute button 
. If necessary, read the documentation for your database.
Note: For PostgreSQL database, after executing your SQL code for a Cron job, if you work in the no auto-commit mode, finish the transaction by clicking Commit button.
Deleting Database Jobs
To delete (drop) a database link, select the needed object in the list of database links and click Delete button.
To delete several database links, right-click the list and choose Multiple Selection. Then select needed database links and click Delete button.
Hint: Database links can also be deleted by the corresponding SQL command.
Opening Existing Database Jobs
Switch to the corresponding tab of the Object Browser. Locate the needed db link or server and select it. This will open a new sub-window displaying the object's properties. Switch to the Script tab to view the DDL code.
Hint: If you double-click the object name in the list, the sub-window will be opened with the Script tab activated.
On the Statistics page, it is possible to see statistics on the launch and execution of the job.
Editing Existing Database Jobs
Open the needed object (see above) and switch to the Script tab. Then click Copy to Editor button 
. The new SQL editor will be opened with the DDL code of the object. Modify it accordingly and click Execute button .
There is another, more powerful way to edit the job: using the Utilities button 
on the General tab. It allows to modify any job attribute without needing to code.
See also