Job Permission | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Job Permission

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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.