sql.LastTimeProcRan

PHOTO EMBED

Tue Nov 02 2021 15:46:48 GMT+0000 (UTC)

Saved by @rick_m #sql

SELECT o.name, 
       ps.last_execution_time 
FROM   sys.dm_exec_procedure_stats ps 
INNER JOIN 
       sys.objects o 
       ON ps.object_id = o.object_id 
WHERE  DB_NAME(ps.database_id) = '' 
ORDER  BY 
       ps.last_execution_time DESC  
content_copyCOPY

https://stackoverflow.com/questions/595742/last-run-date-on-a-stored-procedure-in-sql-server