[arunk]

Pradeepa,

We have the same requirements sometimes back and I can suggest you two ways of doing this.

1. You can create a cron job (time-based scheduling service in your server) and give the email id's of the distribution list, which will automatically execute the script send the results at any specific time. We can mention the time interval of the execution of sql scripts in the cron file.

2. The second one is you can cofigure an schedule report in OTM itself.

Hope this gives you an idea.

Regards
Arun.