Avatar of foxvision

asked on 

Seeing commands of the steps SQL Agent Jobs

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


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?

Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon