Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
what I would like to do is to set that my app will be reloaded on the 1st day of the month and on the 15th of the same month.
On the management console I don't have this chance, but only every day, week, month...
So I thought to set the reload every day and change something in my script that doesn't really reload the app if is not the 1st day of the month and on the 15th of the same month, but I simply don't know how...
Any idea?
Thank u all.
Filiberto
You're right Manuel. But I haven't got a publisher.
Thank you so much anyway.
Another way to achieve the same result is to add this at the start of your load script so the script exits cleanly on the "wrong" days.
// Abort reload if day <> 1 or Day <> 15
If not match(day(Today(), 1, 15) then
trace === Not Day 1 or 15 Reload not run === ;
exit script ;
end if ;
trace === Reload Data === ;
<< Your Reload Script Continues here... >>
swuehl is correct as always.
If the script does not execute, the model will be empty.
This version will force an error, so DistributionTask will rollback last data
IF Day(Today()) <> 1 and Day(Today()) <> 15 then
STORE nonexistingtable into foobar.qvd(qvd);
ENDIF
// your script goes here
One question cleveranjos:
If I use your solution and the reload starts today (June 14), the app loads anything , but in this way I can't display what I've loaded at the 1st of June. Is it clear what I'm talking about?
Yep. I think that's my scenario...
Solutions?
Don't worry, but with the IF solution you will lost your data model.
Other way is create a task on Windows, and reload with a bat.
Other way too, you can do binary reloads, with one app for the model and other file with app. In this case, you can get failed model on days that aren't 1 or 15, but your app don't will be affected.
Regards!
I've used something similar in the past, but then ended up with failed tasks in the status bar and email alerts.
Maybe it's possible to work around the empty data model using a partial reload (is this even possible without the publisher?).
I am now using EDX tasks for these kind of requests. It's pretty simple to setup using the command line executable and the windows scheduler offers more options than the non-publisher QMC.
Store all your tables to QVD on completion of a successful reload on the 1st & 15th.
On other days just load the data from the existing QVDs.
This avoids having errors which will indicate a failed load tasks in the QMC and possibly generate failure emails.
When you talk about binry reloads, what do you mean exactly? Do Do you mean to create 2 apps?