I have a SQL server job which has got different steps, including running a SSIS package. Currently it is on my pc (my local instance).
I should deploy it to UAT and assume some steps need to be taken to deploy it, in terms of creating login which run it, removing my login from it, etc.
Could you please explain the steps involved to deploy it successfully. Please note there is a CLR function call in this job as well, what would you recommend for required security settings around that?
Thank you in advance!