Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

difference between job and scheduler

poornaSep 24 2009 — edited Sep 24 2009

Hi,

Oracle Version : 10.2.0.1

What is the difference between

 dbms_scheduler.create_schedule

and

 dbms_scheduler.create_job

.How there two are related.Here i create a job like this

BEGIN
  dbms_scheduler.create_job(
      job_name => 'DAILY_EXTRACTS'
     ,job_type => 'PLSQL_BLOCK'
     ,job_action => 'begin prc_extracts(); end; '
     ,start_date => TO_DATE('09/23/2009 10:30 PM','mm/dd/yyyy hh:mi AM')+3/24
     ,repeat_interval => 'FREQ=DAILY'
     ,enabled => TRUE
     ,comments => 'scheduler for extracts');
END;

but the job is not running .Here i need to schedule the job name in

 dbms_scheduler.create_schedule

also .

Thanks & Regards,
Poorna Prasad

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2009

Added on Sep 24 2009

#general-database-discussions

9 comments

1,744 views