January 19, 2011 at 10:40 am
Hi,
I am not sure if its possible of not but as per my requirement i need to give permission to a group on a SQL Agent job so that they then run it / stop it / disable it/ enable it.
But that group must not be granted permission on other jobs on that server.
cheers!
DKG
January 19, 2011 at 10:56 am
You can give the ownership of the job to a specific person. That will allow SA to still see/use it but that person as well will be able to control it.
However, you can't give ownership to a group. I don't know why, you just can't.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2011 at 6:13 am
Thanks Craig for reply but it doent meet my requirement i have couple of users in one group which require permission on a particular job to stop/disable/start and enable this job.
cheers!
DKG
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply