I have multiple Sql Agent jobs, with multiple steps each. For a large subset of these jobs, I want to set the logging levels to PERFORMANCE instead of BASIC - the logs are taking a lot of log space, and, more importantly, are causing a slowdown for other processes.
I went into SysJobSteps, but there is no column that I can update. I am considering changing hundreds jobs so doing this manually isn't an option for me.
How do I do this using TSQL?
Here is an image of the 4 options available: