Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-21 : 14:26:22
|
| Lee writes "I have an SQL Server 7 (sp3) running on Windows NT4 (sp6), that is dedicated to running daily feeds to external customers and polulating our data warehouse. There are several jobs that run every day, created and owned by different people. This means that unless all of my users are sysadmin (which I don't want to do - developers with sysadmin rights as you probably know is lethal) only the owner of the job can execute it. What I really want is a group of three or four people that can see and execute all of the jobs in the Server Agent without being system administrators.I want to hand these jobs over to our operations team, but until I can find a way that they can execute these jobs (without owning it or being sysadim) I can't do this. Any suggestions?" |
|
|
|
|
|
SQL Server Agent Jobs - Who can execute them?