Re: SQL job owner and right

If you are using SQL2000 then you need to be sa. In 2005 there are 3 new roles that define the abilities of non-owners in SQL Agent. Check out these in BooksOnLine for more details:

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Lynn" <Lynn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1AE16035-2A1A-4252-A978-196C53ED16C4@xxxxxxxxxxxxxxxx
Hi,

A user has right to create and operate a SQL job, but only limited to the
jobs that this user is created. Without granting sysadmin right, how to
grant a user to be able to operate and change the job which is created by
other users?

Thank you.
--
Best Regards,

Lynn

.

Relevant Pages

  • Re: Error running DTS package on a schedule (only!)
    ... To determine wich account was used by SQL Agent: ... |> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled Backup for SQL Database
    ... and the service does restart ok. ... >> For some reason the SQL agent under server management does not restart ... Only problem is when the SQL server ...
    (microsoft.public.sqlserver.server)
  • Re: Replication Monitor disappears
    ... account and see if it shows up. ... Looking for a SQL Server replication book? ... When I was setting up replication I had SQL ... Finally I was able to start the SQL Agent service by ...
    (microsoft.public.sqlserver.replication)
  • Re: more detail on issue
    ... then have SQL and SQL Agent running as an ... When you installed the package to your SQL ... Server, did it prompt you for the password you packaged with? ... strings not being visible to the SQL Agent user. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server Agent thro SP
    ... fire the start service to start the SQL Agent service. ... to query the state of SQLAgent ... >> I have a requirement in which I need to check if SQL Server Agent ...
    (microsoft.public.sqlserver.server)