Post reply

Can not see the sysadmin login account while trying to run a job as sysadmin job owner.

  • May 18, 2016 at 9:58 am

    #327155

    Ideally if a windows account or SQL is part of the sysadmin group, we can schedule the sql agent job to run that job.

    While I tried to use such account, I can not do so as it does not show up in the drop down under Job Owner list.

    Please suggest.

    Thanks.

  • May 18, 2016 at 10:20 am

    #1879924

    I have fixed this issue while running the below query...need to change the job name and login account details as required.

    update

    sysjobs

    set owner_sid = (select SID from sys.syslogins where name = '%loginname{DOMAIN\GROUP}%')

    where name = '%Jobname%'

    Thanks.

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

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