use T-SQL to change Logging level of SQL Job

Question

use T-SQL to change Logging level of SQL Job

river1

SSC-Insane

Points: 24302
More actions
January 5, 2018 at 3:02 am

#325290

Dear Forum Members,
I have a SQL Job that runs an SSIS package. This job is configurated to use Basic logging but I want to change it to use None Logging.
How can I achieve this using t-SQL? Can someone help me?
BTW, I have already changed in the catalog the property server wide level logging to None and I know what is the difference between None and Basic.
Thank you for the support.
January 8, 2018 at 4:43 am

This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

river1 SSC-Insane Points: 24302 More actions · Answer 1

Reply for this is changing the command below parameter :

SET @sqlJobSSISCommand='/ISSERVER "\"\SSISDB\'+@sqlJobSSISPackagePath+'\"" /SERVER "\"'+@sqlJobSSISServer+'\"" ' + ISNULL(@sqlJobSSISParameters, '')+' /Par "\"$ServerOption::LOGGING_LEVEL(Int16)\"";0 /Par "\"$ServerOption::SYNCHRONIZED(Boolean)\"";True /CALLERINFO SQLAGENT /REPORTING E'

So initially I had : /Par "\"$ServerOption::LOGGING_LEVEL(Int16)\"";1
Now, as you can see above I have changed the value of the parameter :/Par "\"$ServerOption::LOGGING_LEVEL(Int16)\"";0