job execution sql agent
From: p brent (email@example.com)
- Next message: Lionel Johnson: "RE: SQL2000 Network encryption"
- Previous message: Ricky Artigas: "Slammer Worm/SQL Server 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "p brent" <firstname.lastname@example.org> Date: Fri, 21 Feb 2003 11:45:12 -0800
I am using a proxy account to run a scheduled job.
The proxy account is non-sysadmin, and is setup
to do all the DTS stuff required. The jobs run under
this proxy account. I would like to
have developer's (non-sysadmin) manually run job themselves
from EM but they cannot. I tried to give them db_owner
in msdb but they still exec permission errors in system
Any ideas on how to provide developers job run privilege