How to drop a schedule in oracle

Question

254 views17/04/2023Oracle Database

0

Amen1.09K 14/04/2023 0 Comments

How to drop a schedule in oracle? DBA scripts to drop a schedule in oracle?

Ezana Answered question 17/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-17T15:31:37+00:00

The SQL scripts to drop a schedule in oracle:

BEGIN
   DBMS_SCHEDULER.DROP_SCHEDULE(
   schedule_name => 'DAILYREPORTJOB_SCHED',
   force => TRUE
   );
   END;