This discussion is archived
1 Reply Latest reply: Sep 25, 2012 11:52 PM by spajdy RSS

Checking correct creation for oracle Job

848638 Newbie
Currently Being Moderated
Hi,

I want to know if my job will be executed if not appers nothing in job_action into the dba_scheduler_jobs. Because the job appears but not have information in job_action column.

The creation is here:

begin
dbms_scheduler.create_schedule
(schedule_name => 'TEST.WEEKLY',
start_date=> SYSTIMESTAMP,
repeat_interval=> 'FREQ=WEEKLY; byday=mon,tue,wed,thu,fri; byhour=21; byminute=55; bysecond=0',
comments=>' Run every day MON-FRI');
end;
/



Program Example



begin

-- Call a procedure of a database package
dbms_scheduler.create_program
(program_name=> 'TEST.CL_DS_INSERT',
program_type=> 'STORED_PROCEDURE',
program_action=> 'TEST.CL_BOUNDS_UTILS.INSERTS',
enabled=>true,
comments=>'Procedure TEST.CL_BOUNDS_UTILS.INSERTS.'
);

end;

/


Job Example

begin
--

dbms_scheduler.create_job
(job_name => 'TEST.CL_INSERTS',
program_name=> 'TEST.CL_DS_INSERT',
schedule_name=>'WEEKLY',
enabled=>true,
auto_drop=>false,
comments=>'Job to INSERT');
end;
/



please give me your comments

Regards!!

Legend

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