min rights required to schedule a sql server job

Hello,

I need to create a user that can schedule jobs. I cannot use the 'sa' account.

What rights should I assign this user?

Michael

Michael,

You need a user that is a memeber of SQLAgentUserRole database role in msdb database.

You can read more about that in BOL topics:

"How to: Configure a User to Create and Manage SQL Server Agent Jobs"

"Security for SQL Server Agent Administration"

Regards,

|||

Here is the link to the Books Online topic for SQL Server Agent security: http://msdn2.microsoft.com/en-us/library/ms190978.aspx

Cheers,
Dan