Privilege in scheduling packages through sql agent jobs

From: Maria Garcia (MariaGarcia_at_discussions.microsoft.com)
Date: 03/28/05 

Date: Mon, 28 Mar 2005 09:21:08 -0800

A programmer can schedule jobs through sql agent and the job step that is
executed in the job ran cannot be ran in a package that is scheduled.When the
programmer runs the package interactively, it runs fine. When the programmer
attempts to schedule a package as sql agent job, the job fails. I have admin
privileges to sql server. Therefore, I scheduled the job for the package and
had the job run under the programmers account and obtained the following
error:
Non-sysadmins have been denied permission to run CMDExec job step.
Does this mean that the programmer needs to have the system administrator
role in order to schedule a package as a job. 

-- 
Maria Garcia

Relevant Pages

  • Re: Privilege in scheduling packages through sql agent jobs
    ... > How to Run a DTS Package as a Scheduled Job ... >>A programmer can schedule jobs through sql agent and the job step that is ... >>programmer runs the package interactively, ... >>attempts to schedule a package as sql agent job, ...
    (microsoft.public.sqlserver.security)
  • Re: Privilege in scheduling packages through sql agent jobs
    ... It means that if the programmer is not a sysadmin, ... How to Run a DTS Package as a Scheduled Job ... >attempts to schedule a package as sql agent job, ...
    (microsoft.public.sqlserver.security)
  • Re: DTS schedule problem
    ... since I infer from your original post that you are on a SQL Server 2000 ... Who owns the scheduled SQL Agent job? ... the package is under the system account, which was only a SQL account. ... I tried to schedule a DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to Process Cube on 64bit Server with DTS package
    ... Let's see if this is a SQL Agent issues or a DSO issue. ... Can you write a package which executes a TSQL task (using integrated ... >> BI SystemsTeam ... When we try to schedule the DTS package, ...
    (microsoft.public.sqlserver.olap)
  • SSIS Scheduling Failure - AcquireConnection Error
    ... package into SSIS services in Management Studio and ran the job manually. ... I got the dreaded 'AcquireConnection' error when I tried to schedule ... while logged onto the SQL Server 2005 database server itself. ... the 'SQL Agent Service Account'. ...
    (microsoft.public.sqlserver.dts)