Post reply

Permissions for a Application Job

  • October 16, 2009 at 4:03 am

    #211146

    Hi,

    I have one application job running on my server.

    The JOB will run some stored procedures and SSIS package in multiple steps.

    Fob running this scheduled Job, what are the permissions required for JOB OWNER?

    Please suggest me the JOB OWNER permissions...

    Thanks.

  • October 16, 2009 at 4:07 am

    #1066778

    From what I recall, you can leave this as SA.

    Schedule the SSIS package using SQL agent and it will run under the context of the SQL Agent account.

  • October 16, 2009 at 4:41 am

    #1066797

    Initially we have disabled 'sa' for some reason.

    so we to keep some user as a job OWNER.

    So what are the permissions to be given to him?

    **this job consist 4 steps

    3 steps will execute some SPs and 1 for SSIS

  • October 16, 2009 at 9:39 am

    #1067001

    If sa isn't available, my second choice would be the SQL Agent service account. If you want a less privileged login to be the job owner, you'll need to decide if you want that owner to make changes to the job and it's schedule. See the BOL description for the SQL Server Agent database roles in the msdb database.

    Greg

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

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