Re: How to see jobs.

There isn't a supported way to do this as non-sysadmins can
only view or edit jobs they own.
An unsupported method that some have used is to add the user
to the TargetServer role in msdb.

-Sue

On Thu, 19 Jan 2006 13:44:43 -0800, MariaGuzman
<marisa@xxxxxxxxxx> wrote:

>Hi, I have a server running win2003 sp1, sql2000 sp3. I have a user
>programmer that need to see all jobs that are created. The owner of the
>jobs is the services account, and I don´t want to change it.
>
>Do you know if it is possible that can let him to see the jobs without
>be the owner??
>
>thanks a lot for your help.
>
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***

.

Relevant Pages

  • Re: Database Security
    ... the rights to execute jobs with the proxy account. ... user at database level and not server. ... >>from 30 legacy systems) These often fail and the owner ...
    (microsoft.public.sqlserver.security)
  • Re: Database Security
    ... A general response - an owner of a job can run a job that ... they own without being a sysadmin. ... and run their jobs only. ... >2000 server as the OS with SQL server 2000 Enterprise ...
    (microsoft.public.sqlserver.security)
  • Dont stand in front of the fan, Part 7
    ... I've seriously been thinking about changing jobs because it appears that the ... glaciers and I will both be gone before anything good occurs around here. ... owner to do something smart for a change. ... He'll totally screw them up and I'll ...
    (alt.machines.cnc)
  • 1983 Honda Ascot VT500 - Engine clicking noises
    ... current owner brought forward was that the engine started "clicking" ... and have done many jobs, never any valve work though. ...
    (rec.motorcycles)
  • Re: BLACK 3.2 * LOW RESERVE * 1 hour left
    ... Some chunk of shit Audi it turned out to be, one of those hairdresser ... jobs. ... Probably vastly overvalued by the owner, and unloved by the rest of the ...
    (uk.adverts.cars)