This discussion is archived
2 Replies Latest reply: Sep 22, 2012 12:11 AM by Veeresh.S RSS

Schedule a job

735680 Newbie
Currently Being Moderated
Hi,

OS:Windows Server 2008

Database:Oracle 11gR2


I want to schedue a procedure in oracle and not from the Tash scheduler utility.Is there any way to schedule the procedure at database level.

I want to run the procedure daily at specific time.

Regards,
Bobby
  • 1. Re: Schedule a job
    316993 Pro
    Currently Being Moderated
    Yes see DBMS_SCHEDULER package here
    http://www.oracle-base.com/articles/10g/scheduler-10g.php
    Khurram
  • 2. Re: Schedule a job
    Veeresh.S Pro
    Currently Being Moderated
    create and schedule a job using DBMS_SCHEDULER.CREATE_JOB

    BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
    job_name => 'job name',
    job_type => 'STORED_PROCEDURE',
    job_action => 'your procedure name',
    start_date => '28-APR-08 07.00.00 PM Australia/Sydney',
    repeat_interval => 'FREQ=DAILY;INTERVAL=2', /* every other day */
    end_date => '20-NOV-08 07.00.00 PM Australia/Sydney',
    comments => 'My new job');
    END;
    /

    ref : http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse002.htm#
    http://www.orafaq.com/wiki/DBMS_SCHEDULER

Legend

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