Post reply

Scheduled SQL Server job have to run as SQL Agent Service Account?

  • April 10, 2006 at 10:28 am

    #112631

    When scheduling a SQL server 2005 job, does it have to run as a SQL Agent Service Account or can that be changed?  I am running it as a Operating System (CmdExec) job.

    Thanks,

    Manisha

  • April 11, 2006 at 4:24 am

    #631874

    That's  SQL Agent question, not a SSIS question, hence I recommend you try the Agent forum.

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • April 12, 2006 at 3:16 pm

    #632218

    I figured this out  myself.  For those who are interested, you have to set up the credentials and then a proxy woth privileges to run certain types of job.  Then while scheduling the job in the steps specify the job to be run as the proxy created.  By default it runs as Sql Agent start up user and this user may not have the permissions to run jobs of specific sub-systems namely SSIS Package, CmdExec, ActiveXScript etc.

    Thanks,

    Manisha

  • May 1, 2006 at 1:07 am

    #635058

    What's the privileges you have assigned to the Login for which the Credential is created?

    I have a similar issue and I am successful so far, only by giving sysadmin rigths to the SQL Login.

     


    bm21

  • May 3, 2006 at 10:05 pm

    #635830

    I am using the SQL server agent account to run the job. 

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply