ENABLE

The ENABLE procedure enables programs and jobs.

When an object is enabled, its enabled attribute is set to TRUE. By default, newly created jobs and programs are disabled.

If a job is disabled and then enabled, the Scheduler automatically runs the job based on its schedule.

A validity check is performed before the object is enabled. If the object fails the check, the object cannot be enabled, and the corresponding error message is returned. If the object is already enabled, no error is returned.

Syntax

DBMS_SCHEDULER.ENABLE (
job_name              IN VARCHAR2);

Parameters

Considerations

• You can use ENABLE on any schema except the SYS schema.

• When you enable the scheduled partition balancing task SCHEDULED_TRIGGER_PARTITION_BALANCE, the tenant-level configuration item partition_balance_schedule_interval must be set to 0. Otherwise, the error OB_OP_NOT_ALLOW is returned. The configuration item trigger and the scheduled task trigger cannot both be enabled at the same time.

Examples

• Enable the program named job_test.

  obclient(SYS@oracle001)[SYS]> delimiter //
  

  obclient(SYS@oracle001)[SYS]> BEGIN
    DBMS_SCHEDULER.ENABLE(job_name => 'job_test');
  END;//
  

  obclient(SYS@oracle001)[SYS]> delimiter ;
  

• Enable the scheduled partition balancing task.

  obclient(SYS@oracle001)[SYS]> CALL DBMS_SCHEDULER.ENABLE(job_name => 'SCHEDULED_TRIGGER_PARTITION_BALANCE');
  

  or

  obclient(SYS@oracle001)[SYS]> CALL DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');