Four Stars

Runing subjob with different user

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?

Thanks

1 REPLY
Eight Stars

Re: Runing subjob with different user

set connection parameters:
integratedSecurity=true;user=ABC\\dbuser;password=dbpass