Is there a way to run a sub-job from a job with a different user?
I have a main generic job running with a system user, it runs a generic sub-job which writes to MSSQL according to configurations that ask to run with different tables and servers in different schedules, but when writing to MSSQL using AD authentication (like SSPI) I need to run the job with the relevant user for the 1specific DB. Is there a way to choose the user to run the subjob?
