This discussion is archived
1 Reply Latest reply: May 17, 2013 3:59 AM by sushaant RSS

NO ROW IN USER_SCHEDULER_JOBS

Zabo Newbie
Currently Being Moderated
Hello,

I'm using Oracle 11gR2.

I'm using DBMS_SCHEDULER.create_job like this
DBMS_SCHEDULER.create_job (job_name => 'MY_JOB_NAME',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN My_Proc; END;',
start_date => SYSTIMESTAMP,
end_date => SYSTIMESTAMP+1/24,
repeat_interval => 'FREQ=DAILY',
enabled => TRUE,
comments => 'COMMENTS');

From time to time, even after waiting 30 sec, I get no row in user_scheduler_jobs.

How can I explain this ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points