Post reply

Job Owner

  • June 28, 2005 at 8:08 am

    #76359

    Can oneone please let me know the way to find out owner of a sql job . I tried joining sysusers and sysjobs where owner_sid gives the id. but is there a wya to know the user name too who ownes a job.

    any help will be greatly appreciated.

    TIA

  • June 28, 2005 at 8:19 am

    #568918

    exec msdb..sp_help_job @Job_name ='JOB NAME'

     


    * Noel

  • June 28, 2005 at 8:38 am

    #568939

    Thanks that helped. even this gave me the answer.

    select SUSER_sNAME(owner_sid),name from sysjobs

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

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