OraFAQ Forum: Performance Tuning » dbms

Home » RDBMS Server » Performance Tuning » dbms_job package

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_job package [message #169418]

Wed, 26 April 2006 13:28

raviteja
Messages: 4
Registered: April 2006
Location: hyderabad

Junior Member

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM?

Report message to a moderator

Re: dbms_job package [message #169420 is a reply to message #169418]

Wed, 26 April 2006 14:24

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Code: [Select all] [Show/ hide]

DECLARE
    jn       BINARY_INTEGER;
BEGIN
    DBMS_JOB.SUBMIT(jn
    ,               'scott.given_procedure;'
    ,               TRUNC(SYSDATE) + 2 + 9/24
    ,               'TRUNC(SYSDATE) + 2 + 9/24'
    );
END;
/

Report message to a moderator

Previous Topic:	Check My Query Plz
Next Topic:	sizing sort area

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 05:48:00 CDT 2025