Database Software

Hi,

Require means of checking is a job is already running.

I'm not very experienced with Oracle Scheduler. I have a question around use of scheduler on a RAC db. I am able to schedule jobs and get them to run every 15 minutes. There are cases where the job may overrun its scheduled interval of 15 minutes, in such a case i dont want another instance of the job to run. Whats the best way to handle such things using scheduler?

So far the approach I'm taking is - I understand that from gv$scheduler you can understand if the job is running or not. If there were some correlation between gv$scheduler and other tables such as DBA_SCHEDULER_JOBS I might be able to do a query to check if a job created by me was running. No luck so far locating such a link between these tables.

Regards,

PK