SQL 2005 grant run job permission to user
Posted on 2009-02-16
I am having trouble granting users permission to start a job in SQL 2005. Currently I have a program, developed in visual basic 2008, that uses sql tables. These tables need to be updated periodically and sometimes immediately. I have grated the user builtin\users permission into the msdb so that I can start a job using a stored procedure but it isn't working correctly. Currently I get an error of "The specified job @job_name('something') doesn't exist. Now if I run the same procedure from my login, administrator, it works fine. I know it has to do with permissions on the SQL box but I can't find out where to fix it. Good or bad the user builtin\users has execute permissions and is a member of targetserversrole along with db_executor, I made this up to grant execute permissions on the msdb. Where do i go from here? Or what information do you need to help me?