Database Administration (MOSC)

MOSC Banner

dba_scheduler issue

edited Aug 28, 2009 5:08AM in Database Administration (MOSC) 5 commentsAnswered
 I Created the job at 10AM as below

SQL> begin
dbms_scheduler.create_job(
job_name=>'SAMPLE_JOB',
job_type=>'EXECUTABLE',
job_action=>'/u000/app/oracle/rman/test.ksh',
start_date=> '27/AUG/2009 10:17:45 AM',
repeat_interval =>'FREQ=HOURLY;INTERVAL=2',
enabled => true,
auto_drop=>false,
comments => 'sample job'
);
END;
/
 
PL/SQL procedure successfully completed.
 
select * from dba_scheduler_jobs where job_name='SAMPLE_JOB';


JOB_NAME             JOB_ACTION                                                   START_DATE                                         NEXT_RUN_DATE
-------------------- ------------------------------------     -----------------------------------      -------------------------------------------------
SAMPLE_JOB           /u000/app/oracle/rman/test.ksh                               27-AUG-09 10.17.45.000000 AM -04:00                27-AUG-09 10.17.45.000000 AM -04:00

At 10:30 AM, I see the job is not executed as below. What might be the issue

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center