List stored procedures and when they were last run

sprocs.sql

SELECT 
       sc.name, p.name, st.last_execution_time
FROM sys.procedures AS p
       INNER JOIN sys.schemas AS sc ON p.[schema_id] = sc.[schema_id]
       LEFT OUTER JOIN sys.dm_exec_procedure_stats AS st ON p.[object_id] = st.[object_id]
ORDER BY 
       p.name, st.last_execution_time DESC