Adding a SQL Job Definition in Database Manager

You can add a SQL job definition to specify a SQL statement. The scheduled job in the Job Manager view is run based on this SQL statement.

Note: Only the system administrator and users with the required permissions can access these features. These features are not available in Oracle environments.

Select Administration > Database Manager > SQL Job definition. The SQL Job definition window is displayed.
Click New SQL Job definition in the Task Pane. The Add SQL Job definition window is displayed.
Specify this information:
Name

The name that is displayed in the Job Manager.

Description

A brief description of the job.

Query

The SQL query to perform.

You can perform these statements:
- SELECT
- INSERT
- UPDATE
- DELETE
- TRUNCATE
  Note: Truncating a table removes all the data from the table and the data cannot be recovered.
You cannot perform these statements:
- Drop database objects
- Modify schema
- Run statements against the DATABASEADUIT or VIRTUALFILESYSTEM tables
Specify these fields in the Create job schedule to run section to define the job schedule:
- Select the frequency of the job is to be run in the Every field. Possible values:
  - Day
  - Minutes
  - Hour(s)
  - Week day
  - Week
  - Month
- Click the Calendar icon in the at field to specify the time of day when the job is to be run.
- Click the Calendar icon in the Run from field to specify date. The job recurrence starts from this date.
- Click the Calendar icon in the to field to specify date. The job recurrence ends on this date.
Click OK.

Note: The SQL Job definition is created and Enabled by default.