Cacher is the code snippet organizer for pro developers

-- Check last time SP ran.

select	b.name, a.last_execution_time 
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) = DB_NAME() -- Current database or change it to your database name