How can a non-owner start a job?

From: Andrew Drake (andrewdrake_at_hotmail.com)
Date: 07/17/03 

Date: Thu, 17 Jul 2003 12:19:37 +0200

Hi!

We've encountered the following problem:

There is a DTS package scheduled for execution every night as a SQL Server
Agent Job. Both DTS package and Job are owned by a user who is a member of
the sysadmin role. And it works fine.

However, from time to time it is required to run the DTS package (or - what
is equivalent - the job) immediately , and it should be done by a user who
is not the owner of the job.

So it raises the question: How can a non-owner start a job?

MSDN states for sp_start_job:
"Execute permissions default to the public role in the msdb database. A user
who can execute this procedure and is a member of the sysadmin fixed role
can start any job. A user who is not a member of the sysadmin role can use
sp_start_job to start only the jobs he/she owns."

The user who is intended to start the job is not and will be not a sysadmin.

Is there any workaround to this problem?

Many TIA,
Andrew

Relevant Pages

  • Re: Want to run sp_addlogin
    ... Logins with securityadmin fixed server role can also execute sp_addlogin. ... "Dan Guzman" wrote in message ... > Sysadmin role membership is required to execute sp_addlogin. ... > member login before executing the proc. ...
    (microsoft.public.sqlserver.security)
  • Re: Want to run sp_addlogin
    ... Sysadmin role membership is required to execute sp_addlogin. ... member login before executing the proc. ... not have the correct permissions to run the stored proc. ...
    (microsoft.public.sqlserver.security)
  • Re: DTS and stored procedure
    ... The DTS package can be stored in the Microsoft® SQL ... > Displays the command prompt options. ... > of the command used to execute the DTS package because the server name, ... Specify server_name to ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS vs Job Problem for 2 Digit Date format
    ... When you execute a DTS package it comes to you. ... The job will execute on the server itself. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Permissions problems loading DTS file in C#
    ... http://SQLDev.Net/DTS/DotNETCookBook.htm to attempt to load a .DTS package ... in C# through the COM Interop services, and execute it. ... Using explicit path references ... Placing the file on a remote network drive ...
    (microsoft.public.sqlserver.dts)