Oracle scheduler - How to stop logging of jobs
I have 1 job. This job runs every 1 minute.
When I check the history of my jobs through EM it is hard to find any other job, since logging of this job fills my history.
I want this job to stop logging. I found:
BEGIN
DBMS_SCHEDULER.set_attribute (name=>'JOBNAME', attribute =>'logging_level',value=>DBMS_SCHEDULER.logging_off);
END;
I run it but the job is still appearing in my history. Also querying dba_scheduler_job_log entries are still made there.
How can I stop logging this job?
Thanks