Scheduled Job Failing - After Change

[newmediaguy]

Hi Guys

I recently updated the time of a scheduled job on our Oracle system. Now when the job runs or the procedure is run it starts the scheduled job at the same times then fails.

When the scheduled job is started manually it tries to run it 3-4 times resulting in failures.

Has anyone seen anything like this before?

Thanks

Glen
Conception | Execution

 

[KenCunningham]

Glen, are you scheduling the job within Oracle (DBMS_JOBS say), or from the Operating System (using cron perhaps?).

 

[newmediaguy]

Hi Ken

The Job is scheduled vi DBA Jobs which was recently changed with in the last day or 2 to start slightly later.

However last night it failed and when I just went to run the proc the scheduler started at the same time!? which is slightly strange.....

It is just weird.



Glen
Conception | Execution