How can I track the status of a job in progress using Oracle DBMS Scheduler?

Question

Is this possible with the oracle scheduler. I just want to keep track of where it is running when work is running and get feedback.

dbms_scheduler.create_job( job_name => 'hello_oracle_scheduler', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN DBMS_OUTPUT.PUT_LINE('' ''); DBMS_OUTPUT.PUT_LINE(''Hello world of scheduler. Time to execute scheduled jobs!!!''); END;', number_of_arguments => 0 

Answer 1

You better use a spreadsheet and insert / update it to keep track of your assignments. The DMBS_OUTPUT package makes sense in strange cases when you have a console.

Answer 2

I would recommend using the Pablo / Shannon approach to insert a table through proc with the pragma autonomous_transaction parameter. However, another option is to use UTL_MAIL (or UTL_SMTP if 9i or less) to send an email to yourself if it's just quick and dirty.