Home » RDBMS Server » Performance Tuning » dbms_job package
dbms_job package [message #169418] Wed, 26 April 2006 13:28 Go to next message
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?
Re: dbms_job package [message #169420 is a reply to message #169418] Wed, 26 April 2006 14:24 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
DECLARE
    jn       BINARY_INTEGER;
BEGIN
    DBMS_JOB.SUBMIT(jn
    ,               'scott.given_procedure;'
    ,               TRUNC(SYSDATE) + 2 + 9/24
    ,               'TRUNC(SYSDATE) + 2 + 9/24'
    );
END;
/
Previous Topic: Check My Query Plz
Next Topic: sizing sort area
Goto Forum:
  


Current Time: Wed May 22 19:53:45 CDT 2024