Database Administration (MOSC)

MOSC Banner

How to know if an oracle job is running

edited Jan 19, 2012 1:16AM in Database Administration (MOSC) 4 commentsAnswered
Hello,

I've create a job with this command

SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'MyJob();',next_date => to_date('19-01-2012 11:06:37','dd/mm/yyyy hh24:mi:ss'),interval => 'SYSDATE+1/1440',no_parse => FALSE);

I'd like to know how to check if the job is running or doesn't run? Is there som query or GUI which may show some kind of history of the times that the job has been executed and if was successful or was not ?

One more question, is there some document ID which may help me to clarify the difference between the oracle scheduler and the database scheduler?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center