Using the Database Manager SQL Job Definition CRM Details tab

The Database Manager SQL Job Definitions tab allows the administrator to view and manage SQL job definitions. In the detail pane, the CRM Details tab displays the SQL job name and description, the Enabled option, job schedule, and SQL query definition.

Note: Only the system administrator and users with the required permissions can access these features. These features are not available in Oracle environments.
To open the SQL Job Definitions CRM Details tab:
  1. Select Administration > Database Manager > SQL Job Definitions. The SQL Job Definitions list view is displayed.
  2. Click the CRM Details tab.
  3. View or modify this information:
    Name
    The name that is displayed in the Job Manager.
    Description
    A brief description of the job.
    Enabled
    If this check box is selected, the performed SQL job is available to run as scheduled.
    Query
    The SQL statement definition.

    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 DATABASEAUDIT or VIRTUALFILESYSTEM tables.
  4. View or modify available options in the Job Schedule view:
    • 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.
  5. Click Save.
Related topics