<div>
you will need to add the users to SQLAgentOperatorRole. For more information please refer below link<br />
<br />
<a href="https://technet.microsoft.com/en-us/library/ms188283(v=sql.110).aspx" rel="ugc">https://technet.microsoft.com/en-us/library/ms188283(v=sql.110).aspx</a>
</div>


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 [https://technet.microsoft.com/en-us/library/ms188283(v=sql.110).aspx]

<div>
so this one can allow me to script out any SP and jobs I want so that I can keep a backup ?
</div>


so this one can allow me to script out any SP and jobs I want so that I can keep a backup ?

<div>
so if the SP in master DB can I also script that out by this permission ?
</div>


so if the SP in master DB can I also script that out by this permission ?

<div>
&quot;and also &nbsp;you can add the user to sysadmin role&quot;<br />
<br />
so without this I can't do what ?
</div>


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

so without this I can't do what ?

<div>
You can do that without that also
</div>


<div>
so just this role SQLAgentOperatorRole is enough ? so why I need the sysadmin role, or I have someone to generate it for me ?
</div>


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

<div>
no just go ahead with SQLAgentoperator role that will work, no need of sysadmin role
</div>


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

<div>
<div class="content wysiwyg-content">
Dear all,<br />
<br />
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..
</div>
</div>


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..

permission to read SQL server job content and script that out

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.