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?