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;
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: 22781
Registered: January 2009
Senior Member
Was COMMIT issued after executing code above?
Do new logs get generated or were you just seeing old logs?
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.
Previous Topic: How to get Query execution time in seconds using "Show Timing"
Next Topic: description keyword
Goto Forum:
  


Current Time: Tue Sep 16 08:57:57 CDT 2014

Total time taken to generate the page: 0.14556 seconds