on 05-19-2014 11:45 AM
Can we find last execution time of stored procedure in any HANA table or view.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
You may find it by run following sql.
SELECT LAST_EXECUTION_TIME FROM "SYS"."M_SQL_PLAN_CACHE" WHERE STATEMENT_STRING LIKE '%<PROC NAME>%'
Regards,
Phoebe
This is only giving recent sql statements stored in cache. Table contains only last few hours data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.