According to the msdn library, I would have to give the non admin user (User1) SQLAgentUserRole privileges. But it also says that it has to be a local job and not
a multi server job. Is the snapshot agent job a local or multi server job?
Considering the snapshot agent is a local job and i make USER1 the owner of that job. He should be able to run the job rite?
I need to give USER1 the ability to run sp_start_job to start the snapshot agent ONLY! (and not any other jobs). So what are the steps to do this? I also read that the only way to achieve this is by creating a proxy account? Is there
an article somewhere that best describes this?
View Complete Post