Re: Automate AWR report in Grid control

I think OP meant AWR report and not AWR snaps themselves. Grid Control doesn't have AWR report scheduling capabilities - it just presents you an interface to generate it on demand. There are not many cases I can see why this wouldn't suit your needs.

You can schedule OS script/SQL*Plus and use awr*.sql scripts provided in $ORACLE_HOME/rdbms/admin.
You can also call dbms_workload_repository.awr_report_html or dbms_workload_repository.awr_report_text directly.

On Nov 12, 2007 1:59 PM, Vijay Vardhineni <vvardhineni_at_gmail.com> wrote:
> By default AWR runs for every one hour and retains the snapshots for one
> week. You can use the procedure
> DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings
> to modify the settings.
>
>
> Vijay
>
>
> On 11/12/07, Khanna, Prem <prem.khanna_at_eds.com> wrote:
> >
> >
> >
> > Friends,
> >
> > Have anyone tried to automate AWR report in grid control ?
> > Any clue ? ! Do I need to create my own job or report or is there any
> other simple means of doing it ?
> >
> > For example, I need to automate AWR report generation for a couple of
> databases everyday between 7 to 10 AM .
> >
> > Thanks,
> > ~jp~
>
>

-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l