OraFAQ Forum: SQL & PL/SQL » DBMS

Blog
Search
Help
Members
Register
Login
Home

Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_JOB Question

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

DBMS_JOB Question [message #6825]

Wed, 07 May 2003 08:27

Owen
Messages: 18
Registered: September 1999

Junior Member

I have a procedure called RESETINCIDENT. I want to schedule it to run at the beginning of each new year using DBMS_JOB. Can anyone help me with the syntax? Thank you!

Report message to a moderator

Re: DBMS_JOB Question [message #6830 is a reply to message #6825]

Wed, 07 May 2003 12:24

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

declare
  v_job  number;
begin
  dbms_job.submit(
    v_job, 
    'resetincident;', 
    trunc(add_months(sysdate, 12), 'y'), 
    'trunc(add_months(sysdate, 12), ''y'')');
  commit;
end;
/

Report message to a moderator

Previous Topic:	Cursor Usage
Next Topic:	Use of UTL_FILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:21:58 CDT 2024