OraFAQ Forum: Client Tools » Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING

Home » SQL & PL/SQL » Client Tools » Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set (11g 11.2.0.1 , windows server 2008r2 standard)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set [message #614850]

Tue, 27 May 2014 13:57

JP10
Messages: 29
Registered: May 2014
Location:

Junior Member

Hello,

I set the logging level to off, but when I click on the "Run Log" tab in SQLDeveloper is still see records being logged for the job I created? How do I get this "Run Log" from SQLDeveloper from creating logs? I don't want logs filling up space on my drive so I want it off. Appreciate the help.

BEGIN
  DBMS_SCHEDULER.SET_ATTRIBUTE ('UPDATE_FR_SETTING', 'logging_level', DBMS_SCHEDULER.LOGGING_OFF);
END;

Report message to a moderator

Re: Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set [message #614851 is a reply to message #614850]

Tue, 27 May 2014 14:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Was COMMIT issued after executing code above?
Do new logs get generated or were you just seeing old logs?

Report message to a moderator

Re: Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set [message #614852 is a reply to message #614851]

Tue, 27 May 2014 14:47

JP10
Messages: 29
Registered: May 2014
Location:

Junior Member

commit was executed and new logs are being generated still.

Report message to a moderator

Previous Topic:	How to get Query execution time in seconds using "Show Timing"
Next Topic:	description keyword

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 05 02:51:50 CDT 2021