It is always good to keep a track or log of all the activities that were going on in the DB server .
So What is the idea
Keep a track of all the compiled procedures from the last day
- A Copy of log on the server and
- Mail the daily report to your Id with Cronjob utility
So that when somebody in your team or your manager ask you anytime this question you need not login the server and execute the query , You have it in your inbox everyday.
This script help's you to maintain the log of all the proc's compiled for the day ,