Post reply

Advantages/Disadvantages of using Sa as JOb Owner of schedule jobs

  • March 2, 2010 at 11:19 am

    #96230

    Windows Login having admin privileges on sql server 2000 sp4 server. Sometimes job fails with same The owner () of job <Job Name> does not have server access".

    So, thinking to change it to SQL Server Login. What permissions should be assigned to it, which would be enough to run/configure jobs?

    Else is it better to set 'sa' as Job owner for all jobs?

    Please suggest.

    Thanks

    With regards,

    Ankur

  • March 5, 2010 at 2:36 pm

    #1129474

    unless someone else needs to execute or modify the jobs it is better to use sa for the job owner. There are no dependencies this way and you can just document the job under the description.

    This is especially true in sql 2k where you can't really segregate the job responsibilities with database roles.

    Regards,

    Toby

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

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