SELECT
    sv.name AS [Name],
    sv.job_id AS [JobID],
    l.name AS UserName
    FROM
    msdb.dbo.sysjobs_view AS sv
    INNER JOIN [master].[sys].[syslogins] l ON sv.owner_sid = l.sid
       --WHERE l.name <> 'parvez'
    ORDER BY
    sv.[Name] ASC
 
No comments:
Post a Comment