Securables for server level.

Question

Securables for server level.

Motomoto

Right there with Babe

Points: 799
More actions
March 26, 2012 at 9:06 am

#258249

permission should be granted to users on the server level so that they can have the ability to create sql jobs and schedule them?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

patrickmcginnis59 SSCertifiable Points: 6483 More actions · Answer 1

Abdul Walele (3/26/2012)
permission should be granted to users on the server level so that they can have the ability to create sql jobs and schedule them?

http://msdn.microsoft.com/en-us/library/ms187901.aspx looks to be the page to read for this!

CapnHector SSCoach Points: 16143 More actions · Answer 2

patrickmcginnis59 (3/26/2012)
Abdul Walele (3/26/2012)
permission should be granted to users on the server level so that they can have the ability to create sql jobs and schedule them?
http://msdn.microsoft.com/en-us/library/ms187901.aspx looks to be the page to read for this!

http://msdn.microsoft.com/en-us/library/ms188283.aspx

i actually think this is what he is looking for. im guessing you are using sql server agent.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

patrickmcginnis59 SSCertifiable Points: 6483 More actions · Answer 3

capn.hector (3/26/2012)
patrickmcginnis59 (3/26/2012)
Abdul Walele (3/26/2012)
permission should be granted to users on the server level so that they can have the ability to create sql jobs and schedule them?
http://msdn.microsoft.com/en-us/library/ms187901.aspx looks to be the page to read for this!
http://msdn.microsoft.com/en-us/library/ms188283.aspx
i actually think this is what he is looking for. im guessing you are using sql server agent.

Looks like you're right, good catch!

CapnHector SSCoach Points: 16143 More actions · Answer 4

he might need both depending on what he is trying to accomplish. if he is using xp_commandshell to interact with the OS then he will most likely also need proxy accounts.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]