Hi,
version 11.2.0.3
We have a dbms_scheduled job which runs every 5 mins.
It is taking longer e.g. 6 or 7 mins now such that would like to change frequency of job to 10 minute intervals.
What is best way to do this without impacting existing running job i.e. don't want to stop and cause it to fail?.
Can we disable it gracefully such that lets current run finish believe in past may not allow disable a running job or can we set attribute to adjust interval while existing job running.
Thanks