How to know if an oracle job is running
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?