Re: Identifying Unused Stored Procedures

Hi Donald, I don't think IDS stores any information regarding last execution/creation time of a routine. Hence, this is almost no way to find this out the past history through IDS. In the future, if this data is needed, you might need to create a log table to track this through the routine itself to add a line at the end to insert the time and routine name. Another way you can consider is using SQL tracing with the SQL Administration API via OAT(OpenAdmin Tool). Hope this might help a bit. Regards, Ken