RRinTetons
IS-IT--Management
I have a cmd file that starts a job. It looks like:
It works fine for me, but I'm sysadmin on the MyServer. I want to give it to a user and let them use it as needed.
What is the best way to set up permissions for this? The user has no other access to this server.
-
Richard Ray
Jackson Hole Mountain Resort
Code:
SQLCMD -S MyServer -Q "USE MSDB EXEC sp_start_job @job_name = 'MyJob'"It works fine for me, but I'm sysadmin on the MyServer. I want to give it to a user and let them use it as needed.
What is the best way to set up permissions for this? The user has no other access to this server.
-
Richard Ray
Jackson Hole Mountain Resort
