permission to read SQL server job content and script that out

marrowyung
marrowyung used Ask the Experts™
on
Dear all,

What should be the permission I need to script out SQL server SP and SQL job? I need to backup sth I wrote for SQL server ? script/SP, etc..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Gaurav SinghSolutions Architect

Commented:
you will need to add the users to SQLAgentOperatorRole. For more information please refer below link

https://technet.microsoft.com/en-us/library/ms188283(v=sql.110).aspx
marrowyungSenior Technical architecture (Data)

Author

Commented:
so this one can allow me to script out any SP and jobs I want so that I can keep a backup ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
so if the SP in master DB can I also script that out by this permission ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Find out now!
Solutions Architect
Commented:
Yes, and also  you can add the user to sysadmin role
marrowyungSenior Technical architecture (Data)

Author

Commented:
"and also  you can add the user to sysadmin role"

so without this I can't do what ?
Gaurav SinghSolutions Architect

Commented:
You can do that without that also
marrowyungSenior Technical architecture (Data)

Author

Commented:
so just this role SQLAgentOperatorRole is enough ? so why I need the sysadmin role, or I have someone to generate it for me ?
Gaurav SinghSolutions Architect

Commented:
no just go ahead with SQLAgentoperator role that will work, no need of sysadmin role

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial