SQL Server Performance Forum – Threads Archive

Permission to view/create/edit/delete SQL jobs

Dear all,
I need to provide a user to view/create/edit/delete SQL jobs in SQL Server 2005.
How to proceed on this . Thanks, DBA
SHAMS

---

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=137 and refer to the books online
about new SQL Server Agent roles, users must be a member of one or more of the following fixed database roles: SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>