SQL Server Performance Forum – Threads Archive

Job Permission

Hello,
I have a question regarding permission to run a job on SQL 2K. I have a table with an update trigger on it. The update trigger calls a job. The login that’s being used by the developer has db_ddladmin, db_datareader, and db_datawriter permission to the database with the trigger on it. My quesion is that since the developer is calling a job, does he need any other permissions to run the job? If so, could you please let me know what it is? I have set the developer’s login as the owner of the job. Thanks in advance for any help! Rinu

Then ensure the SQLAgent has required privileges to perform the trigger operation when calling the job. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>