job access

I thought I had read that in SQL 2k5 we would be able to give a non-sa user
access to specific jobs, but I can't find how to do this. Is it
possible? If so, can someone tell me how?
Thanks, AndreHi
You have to create proxy account. Lookup BOL
"Andre" <nospam@.spam.com> wrote in message
news:%23zuEqCe2HHA.3900@.TK2MSFTNGP02.phx.gbl...
>I thought I had read that in SQL 2k5 we would be able to give a non-sa user
> access to specific jobs, but I can't find how to do this. Is it
> possible? If so, can someone tell me how?
> Thanks, Andre
>
>|||Yes...different levels of access based on different
configuration options of proxies or using the new database
roles in msdb. Check the following topics in books online:
How to: Configure a User to Create and Manage SQL Server
Agent Jobs (SQL Server Management Studio)
SQL Server Agent Fixed Database Roles
Creating SQL Server Agent Proxies
-Sue
On Wed, 8 Aug 2007 10:22:15 -0700, "Andre" <nospam@.spam.com>
wrote:

>I thought I had read that in SQL 2k5 we would be able to give a non-sa user
>access to specific jobs, but I can't find how to do this. Is it
>possible? If so, can someone tell me how?
>Thanks, Andre
>|||Thanks Sue - I'll check this out.
Andre