Security for Jobs

From: Brian K. (brian.kramer@polarisind.com)
Date: 02/05/03 

From: "Brian K." <brian.kramer@polarisind.com>
Date: Wed, 5 Feb 2003 08:49:42 -0800

Situation: Multiple developers require the ability to
restart jobs when failure has occurred. Currently they
are part of the 'Systems Administrators' Server Role to be
able to see and re-start failed jobs through Enterprise
Manager.

Question: Is there a way to allow them to see jobs
through Enterprise Manager with them removed from 'System
Adminstrators' Server role. I would think that you could
allow them have certain permissions on the tables,
extended stored procedures and regular stored procedures.
Does anyone know of the correct permission to allow them
to do this.

I don't expect this to be a easy one.

Thanks in advance for any responses.

Brian K.

Relevant Pages

  • Re: SQL Server JOBS
    ... Are you trying to create jobs using DDL? ... stored procedures to both create and query jobs. ... The same is for Alerts. ... > I am developing a windows application where i need to give users alerts ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Group Multiple Jobs in Oracle Scheduler
    ... I need to be able to group jobs with common functionality. ... I have x amount of jobs (read stored procedures) that update my stock ... oracle so that job names, processing steps, status information, return ...
    (comp.databases.oracle.server)
  • Re: SQL Server JOBS
    ... > stored procedures to both create and query jobs. ... The same is for Alerts. ... >> I am developing a windows application where i need to give users alerts ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: permissions to view jobs but not change them
    ... Sorry, I meant view jobs... ... > Tibor Karaszi, SQL Server MVP ... >> is there any combination of permissions or a role that will let a user view ... >> stored procedures and their success without being able to modify them? ...
    (microsoft.public.sqlserver.server)
Loading