DataBase/SQL Server
프로시저 마지막 호출시간
탑~!
2026. 4. 30. 09:51
SELECT NAME,
lastdate
FROM (SELECT b.NAME,
Max(a.last_execution_time) AS lastdate
FROM sys.dm_exec_procedure_stats a
INNER JOIN sys.objects b
ON a.object_id = b.object_id
WHERE Db_name(a.database_id) = 'SkyPro'
GROUP BY b.NAME)z
--WHERE name LIKE 'SP_QA_LTM030_%'
ORDER BY name DESC
728x90
반응형