ENABLE

The ENABLE procedure enables a program or job.

When an object is enabled, the enabled parameter of the object is set to TRUE. By default, a newly created program or job is 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 schemas except for the SYS schema.

• To enable the SCHEDULED_TRIGGER_PARTITION_BALANCE job, the tenant-level parameter partition_balance_schedule_interval must be set to 0. Otherwise, an error OB_OP_NOT_ALLOW is returned. The trigger and scheduled job cannot be enabled at the same time.

Examples

• Enable the procedure 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 balance job.

  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');