Is there any way so that I can change the set values in sql agent job through TSQL.
Here is my case.
I have a job which runs SSIS package, ssis variable value is passed through step set value field.
I have to process data based on the rule written on sql and based on the rule I want to change the set value from the sql code.
Thanks in advance.