Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate AWR Report automatically every day

Arun Natarajan-OCJan 7 2014 — edited Jan 8 2014

Hi Friends,

I would like to generate AWR Report automatically every day. How do i do it.

The Start Time will be 00:00 of Previous day and the end Time will be : 00:00 of current day. The File format is html.

Currently i am using awrrpt.sql to generate report manually and i would like to achieve it automatically,I am not sure how to pass the values of start and end time (From which table i can get the values)?

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2014

Added on Jan 7 2014

#general-database-discussions

9 comments

3,917 views