Database Administration (MOSC)

MOSC Banner

Oracle scheduler - How to stop logging of jobs

edited Jan 3, 2022 10:41AM in Database Administration (MOSC) 4 commentsAnswered ✓

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

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