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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Granting permissions to SQL Jobs

Author  Topic 

iwenc01
Starting Member

4 Posts

Posted - 2007-10-17 : 15:39:11
Hello-

I have a couple people who need to be able to see/ modify/ execute jobs on a SQL2000 Server, even though they are not the owner of the jobs.

I know these people could do this if they had SA, but that is not something that I want to give them.

Is there another way they could see/ modify/ and execute these SQL jobs?

Thanks!

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-17 : 18:44:41
I actually ran into this myself before and bookmarked a solution from another forum. You can check it out here: http://www.sqlservercentral.com/Forums/Topic198342-5-1.aspx




Future guru in the making.
Go to Top of Page
   

- Advertisement -