Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BCA schdule refresh

Status
Not open for further replies.

pushkarb

Programmer
Joined
Oct 6, 2003
Messages
1
Location
DE
Hi,

I have some reports scheduled to run Every morning 5:30
Before that there is an ETL process which will load the data in warehouse tables.

i have a Analyze schema script running 7:00 morning.
Surprisingly, the report refresh do not start untill 7:05. So i schduled the anlyse schema at 5:15 and the report refresh starts at 5:30.

Is there any dependency for report refresh and Analse schema?

TIA,
Push
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top