I need to allow a user only to execute a specific Agent job, rather than be able to execute the other jobs that are there . Please advise how to accomplish this.
This user will only run a copy only backup before he updates the application and I don't want to give him access to the other jobs. Ola Hallengren scripts are used for that job.
I added the user to the
DB_BackupOperator role. If I simply make him the owner of that job will he be able to run the other jobs that are owned by SA?