Home » SQL & PL/SQL » SQL & PL/SQL » dbms_job interval
dbms_job interval [message #206201] Wed, 29 November 2006 03:21 Go to next message
suvv
Messages: 17
Registered: October 2006
Junior Member
I want to schedule our job to be run as jdba user on our database wi45
also to be run at regular intervals(every midnight).Please verify this
command to schedule our job at regular intervals(every midnight 1:00 AM).
Is this the right command ?

variable jobno number;
BEGIN
DBMS_JOB.SUBMIT (:jobno, 'job_code;', trunc(sysdate) + 1,'sysdate + 1');
COMMIT;
END;
Re: dbms_job interval [message #206209 is a reply to message #206201] Wed, 29 November 2006 03:38 Go to previous message
suvv
Messages: 17
Registered: October 2006
Junior Member
i got the solution thanx
Previous Topic: How to use run dos to connect ftp
Next Topic: Error while selecting the data
Goto Forum:
  


Current Time: Mon Dec 05 15:19:15 CST 2016

Total time taken to generate the page: 0.10534 seconds