Friday, March 9, 2012

How to read or view job information...

I am attempting to view or read job information in SQL
Server 2000. I do not have 'sa' rights to view job
information.
Please advise...
Thanks,
BrettBrett,
SQL Agent jobs are viewable to the job owner (which could be you) and by
sysadmins. If you need to check the contents of a job and you have a
responsive DBA, he could script out its contents for you. (All questions of
security and process within your organization are outside the scope of this
post.)
There is a trick that works with SQL Server 7.0 and 2000, which is to assign
a user in msdb to the TargetServersRole role. This allows anyone in this
role to see the contents of jobs, look at their schedules, and so forth.
However, anyone who is in TargetServersRole can no longer create a job of
his own.
Russell Fields
"Brett" <brett_davs@.ameriquest.net> wrote in message
news:098301c377c5$29b0ef70$a001280a@.phx.gbl...
> I am attempting to view or read job information in SQL
> Server 2000. I do not have 'sa' rights to view job
> information.
> Please advise...
> Thanks,
> Brett
>

No comments:

Post a Comment