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?

Report message to a moderator

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;
/

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 28 06:23:38 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.