How to Find the last Execution DateTime for a Sproc

Have you ever wanted to find out the last time a stored procedure was executed, if ever? Here is a T-SQL snippet that will return the date and time of the last execution of the list of stored procedures provided in a the WHERE clause listed. It will return NULL for those stored procedures that have never been executed.

Views – 511

Leave a Reply