I want to know how I can look at my QV refresh schedule over a period of time.
So I have a set of qvws that are scheduled to run every hour. I would like to check if any of those refreshes failed over the past week or past month. Is there a way I can do that. I remember seeing something in QV Management Console.
I have a Parent QVD Generator qvw that takes about 3 hours to refresh and upon its successful completion it triggers the refresh of 4 others qvws which pull data from the qvds generated by the Parent QVD Generator.
Hence my question is
Lets say my Parent QVD generator is set for an hourly refresh
I start my refresh at 10:00 am and it completes around 12:55 pm. Hence the other 4 qvws refresh are triggered at 12:55 and they simultaneously finish at 1:05 pm.
However in the mean time at 1:00 pm does the Parent QVD Generator qvw starts its refresh again (this time an incremental one and hence takes far less time and creates delta qvds). If it does start then is there a chance that any of the 4 qvws or its data might get corrupted if it happens?
You should set up your schedule so you are not trying to write to a QVD that someone is reading. Problems can be failed reloads or in some cases corrupted QVDs. Off the top of my head I can't think of the scheduling trick for your scenario but I'm sure someone else will chime in.