exec dbms_defer_sys.schedule_purge(next_date=>sysdate,interval=>'sysdate+1/
24',delay_seconds=>0,rollback_segment=>'');
BEGIN dbms_defer_sys.schedule_purge(next_date=>sysdate,interval=>'sysdate+1/24',
delay_seconds=>0,rollback_segment=>''); END;
*
ERROR at line 1:
ORA-23421: job number 1 is not a job in the job queue
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 3010
ORA-06512: at line 1
and I select * from dba-jobs
SQL> show parameter job
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
SQL> select job, log_user, what from dba_jobs
2 ;
JOB LOG_USER
---------- ------------------------------
WHAT
--------------------------------------------------------------------------------
1 SYS
declare rc binary_integer; begin rc := sys.dbms_defer_sys.purge( delay_seconds=>
0); end;
2 REPADMIN
declare rc binary_integer; begin rc := sys.dbms_defer_sys.push(destination=>'REP
2.COM'); end;
3 REPADMIN
JOB LOG_USER
---------- ------------------------------
WHAT
--------------------------------------------------------------------------------
dbms_repcat.do_deferred_repcat_admin('"SCOTT_REPG"', FALSE);
4 REPADMIN
declare rc binary_integer; begin rc := sys.dbms_defer_sys.push(destination=>'SCO
TT_REPG'); end;