Situatie
Mai jos este o procedura ce listeaza joburile si proprietarii lor pe un server MSSQL.
Solutie
create procedure ListJobsAndOners
as
SELECT
J.NAME AS JobName
J.date_created,
J.date_modied,
L.NAME AS OwnerName,
FROM msdb..sysjobs J
LEFT JOIN master.sys.syslogins L ON J.owner_sid = L.sid
order by 1
Leave A Comment?