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 2005 Forums
 SQL Server Administration (2005)
 User Access to SQL Server Jobs

Author  Topic 

dba.learner
Starting Member

2 Posts

Posted - 2008-07-15 : 12:13:13
Hi all,

I need expert advice.

I have a request from one of our user, who wants to

1. Create and Schedule jobs
2. View Job History
3. Execute Job, whenever required.

Our environment is on SQL Server 2005, and i dont want him to be granted Admin rights

Your help could be appricaited

DL

Regards

Dba.Learner

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-15 : 12:55:00

Look at this one:

http://www.mssqltips.com/tip.asp?tip=1041
Go to Top of Page
   

- Advertisement -