Post reply

What access does a user need to run a job that is a dts pkg

  • May 3, 2007 at 1:00 pm

    #92396

    Person X created a DTS package that runs under DB1. Person Z wants to be able to execute that job. I cannot figure out what rights (other than 'sa') to give them to be able to execute that job.... Person Z currently has read/write access to the db.  SQL 2000 SP4.

  • May 4, 2007 at 9:13 am

    #704376

    Based on this

    --------------------------SQL BOL-----------------------

     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.

    ----------------------------------------------------------

    I believe you have to create a second copy of the job and make that person the owner of the job so they can do it from the server. I do believe this applies to using EM as well to start the job. Basically copy all the steps and there contents to a new job and make the person who wants to be able to run it the owner, then they should be able to.

Viewing 2 posts - 1 through 1 (of 1 total)

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