Oracle-DBMS jobs scheduler change the start time

oracle dbms-job
Vinod Chelladurai picture Vinod Chelladurai · Feb 21, 2014 · Viewed 13k times · Source

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

Answer

124 picture 124 · Feb 21, 2014

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()

Related questions

How to stop Oracle dbms_job

My dbms_job has been running for nearly thirty days. The number of total time keeps rising, but I can't find any info of the running job. When I execute sql that is "select * from dba_jobs;", the result shows …

Read More
Script to disable all jobs in Oracle (DBMS_JOB package)?

I'm looking for a script which disables all the jobs. Right now I highlight them all in Toad, click the take offline button and then commit changes. There has to be a way to do this in PL/SQL.

Read More
View the DBMS jobs log oracle

I have a scheduled a job in DBMS jobs (not DBMS scheduler). I can see the job has failed in weekends. I want to see the log file with failure reason. Where i can i find this? Any suggestions please? …

Read More