on 05-06-2015 7:54 AM
Experts,
Please share your experience. If i have a daily recurring Instance running which I stopped for 5 days. When i resume that instance will it pick and run the instances from the day it was stopped or it will pick from the day it was started. Please share your valuable experience.
from the day it started again.
BR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can get the missing instances ONLY IF you have snapshots of your database on daily basis, but would be tricky and laborious(I'm not going into the transaction log thing here). If you have a test machine, you can take the daily backup from your DBA, restore the db and then run the schedule on the test machine. You have to repeat it 5 times to get the data of all 5 days. Finally, you have to restore with the db to the present state.
In the future if you would like to avoid these type of situations, you can create a report on your TEST(QA, UAT) machine which points to the production database. For some reason if you want to stop the schedule in PROD, still the test server schedule will run and you will have the production data.
OR a report which is scheduled only to you in PROD itself, if you have rights to do that.
Hope it makes sense.
Regards,
Naras
@ Jawahar - Some reports are designed to bring the previous day data. But we will sill be missing some data for the days report didn't run. I thought when i resume the instance it will run from the day it was stopped and maintain the history
@Naras - We don't have daily snapshot. Even if the reports are scheduled to me in prod, if the instance is stopped. How would it generate the report?
In you initial post you had mentioned that you are the person to stop the instance. So, if the schedule is to deliver it to multiple people and you want to stop it you will also not receive it(just like what happened to you now).
But in case if you have a second schedule that will run only for you, you will keep receiving the instances. Even if you stop the actual schedule YOU will still receive it while OTHERs won't.
So under history, you will see two "Recurring" instances. 1st one the normal one, runs for everyone and 2nd one special only for you.
Yeah, there is a downside, you will receive the emails twice and you are loading the server bit more. But if receiving the instance each day is your highest priority, nothing should matter.
Regards,
Naras
Please refer my initial response. If you have a test server, you can create a new Relational connection to point to the PROD database and get the production data through your BOE test server. this is to make sure all other assets on your test server still points to the test database.
On your test or sandbox BOE server,
If you are not sure what I mean here, best to reach out to a report developer in your company who can help you with this one.
Still I'm not clear or sure why the production server would be brought down when you feel it is importance to have instances in your inbox.
Thanks and regards,
Naras
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.