CODEWITHSUNDEEP
oracle-databasedbms-job
Vinod Chelladurai
Vinod Chelladurai

Reputation: 539

Oracle-DBMS jobs scheduler change the start time

I have a DBMS_jobs which is scheduled to run a procedure FINDING_PROCEDURE at 6 am evey day. Can anyone tell me how can i change the start time so that it is scheduled to run at 9 am from tomorrow. Thanks in advance.

enter image description here

Upvotes: 2

Views: 18749

Answers (2)

Frank Schmitt
Frank Schmitt

Reputation: 30775

As I already mentioned in my comment - your job doesn't run at 6 am every day, it runs every 21 hours.

As a second remark, you should seriously consider switching to DBMS_SCHEDULER - it's so much nicer than DBMS_JOB.

Anyway, to let this job run at 9am every day, this should do the trick:

DBMS_JOB.CHANGE (
   job       => your_job_id,
   interval  => 'trunc(sysdate) + 1 + 9/24');

Upvotes: 1

NiiL
NiiL

Reputation: 2827

you can use DBMS_JOB.CHANGE() to Alter your job schedule.

Click on this link for complete reference from

Oracle Documentation:DBMS_JOB

and find DBMS_JOB.CHANGE()

Upvotes: 1

Related Questions