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)
Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set [message #614850] Tue, 27 May 2014 13:57 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 26207
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Oct 23 02:18:07 CDT 2018
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.