Optimise Aggregation Job Erroring
I run the job twice with 5 min separating
1) To enable query tracking
2) Execute Agg Process with parameters
- Based on query data ? Y
- Include Rollup Option ? Y
- Enable alternate rollups ? N
- Include Growth Size Option ? Y Stop when Size exceeds 1.01
First job runs fine but 2nd job fails with
'Failed to select any new views or all views that you requested to build exist already'
Should I increase the time before the second job runs, perhaps the query tracking is not completing ? Are the parameters correct for the 2nd job ?