Serveroutput from dbms_schedule job
Hi everybody,
I'm looking for a solution to catch the serveroutput (e.g. by dbms_output.put_line()) from out of a job scheduled via dbms_schedule (in this case a PL/SQL procedure).
My goal is to click the job in grid control and then the output (some status messages like "xxx rows processed") is shown.
I know that this is simply possible with OEM jobs ("set serveroutput on", "dbms_output.put_line('some_text')) but I would prefer to let my jobs run database bound (->dbms_scheduler). These jobs behave different from those global OEM jobs (don't accept "set serveroutput on").
As I read it is not possible to populate dba_scheduler_job_log or dba_scheduler_job_run_details with custom messages (is that right?).
Any ideas how to capture messages and put them out somewhere instantly readable?
Thx in advance
Stephan