<div>
Much easier than I thought it would be.....<br />
<br />
select command from msdb..sysjobsteps<br />

</div>


<div>
I guess the rights we are having now on MS SQL 2000 is somehow restricted.<br />
<br />
Running &quot;Select command from msdb..sysjobsteps&quot; gives us:<br />
<br />
SELECT permission denied on object 'sysjobsteps', database 'msdb', owner 'dbo'.<br />
<br />

</div>


<div>
need to have someone give you select permissions on the table. &nbsp;strange that you can view the other tables but not that one...
</div>


<div>
<div class="content wysiwyg-content">
There is a need for us developers to see SQL Agent jobs in MS SQL 2000 which we currently do not have rights to see, however we cannot be granted sysadmin rights, meaning we cannot update the jobs but only reading them.<br />
<br />
I have checked the article from<br />
<br />
<a href="http://www.builderau.com.au/program/sqlserver/soa/How-do-I-assign-permissions-to-users-to-see-SQL-Agent-Jobs-/0,339028455,339293647,00.htm" rel="ugc">http://www.builderau.com.au/program/sqlserver/soa/How-do-I-assign-permissions-to-users-to-see-SQL-Agent-Jobs-/0,339028455,339293647,00.htm</a><br />
<br />
and this one is exactly what we want so that we can see the details of the jobs by using a stored procedure.<br />
<br />
However, we can't see the commands in those steps using that stored procedure.<br />
<br />
How can we see the command of the steps in the jobs without given sysadmin rights in MS SQL 2000?<br />
<br />
Thanks,<br />
Fox
</div>
</div>


There is a need for us developers to see SQL Agent jobs in MS SQL 2000 which we currently do not have rights to see, however we cannot be granted sysadmin rights, meaning we cannot update the jobs but only reading them.

I have checked the article from

http://www.builderau.com.au/program/sqlserver/soa/How-do-I-assign-permissions-to-users-to-see-SQL-Agent-Jobs-/0,339028455,339293647,00.htm

and this one is exactly what we want so that we can see the details of the jobs by using a stored procedure.

However, we can't see the commands in those steps using that stored procedure.

How can we see the command of the steps in the jobs without given sysadmin rights in MS SQL 2000?

Thanks,
Fox

Seeing commands of the steps SQL Agent Jobs

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.