Scheduling QVD loads

[#1]

Hello Experts,

I was wondering if we can schedule the QVD reloads to trigger based on an update in the Data base? I have something like the below code which is sent as an email soon as the DB updates the DWH cubes I am using:

SELECT 'Y'

FROM DUAL

WHERE EXISTS (

SELECT *

FROM w_onvglo_job_logging

WHERE progname = 'w_onvdwh_orders_pkg.summarise_orders'

AND TRUNC (log_end_date) = TRUNC (SYSDATE)

AND log_params = 'P'

AND log_success = 'Y')

Is there a way for the QV server to check that this flag is Y and then trigger the reload everyday?

Thanks in Advance,

ANDY

[#2]

Any takers please?

Thanks Again

[Miguel_Angel_Baeyens · Accepted solution]

Hello Andy,

You can create a very simple QVW file that is being reloaded continuously. This file only reads that flag. Then create another reload task but this one is set to reload "On event of another task" "Successful" and select the file that is reading the flag.

Hope that helps.

[#4]

Hello Miguel Thank you for the quick and the short yet correct reply. But I might comeback if there are more issues ;).

Thanks Again

[#5]

Hello Miguel,

I have the below code in one of my Flag.QVW's as posted here and the plan is to check for a flag Field "LOG_SUCCESS"
from DB which should be 'Y' for the PROGNAME 'w_onvdwh_orders_pkg.summarise_orders' and then I want the QVW to reload. After this I want a set of QVDs(or QVWs) to reload based on the sucessful reload of Flag.QVW

I am thinking this is simple, but isnt feeling confident doing it. Can someone please explain the process in a bit detail how this can be achieved?

Thanks a Ton in advance,
ANDY

LOAD
PROGNAME,
"LOG_START_DATE",
"LOG_END_DATE",
"LOG_PARAMS",
"LOG_SUCCESS";

SQL FROM
"OPS$WSFONV"."W_ONVGLO_JOB_LOGGING"
WHERE
PROGNAME = 'w_onvdwh_orders_pkg.summarise_orders'

[Miguel_Angel_Baeyens]

Hello Andy,

The following should work, but the syntax may vary depending on the driver to connect to the database:

FlagTable:LOADPROGNAME, "LOG_START_DATE","LOG_END_DATE","LOG_PARAMS","LOG_SUCCESS";SQL SELECT PROGNAME, LOG_START_DATE, LOG_END_DATE, LOG_PARAMS, LOG_SUCCESS FROM "OPS$WSFONV"."W_ONVGLO_JOB_LOGGING" WHERE PROGNAME = 'w_onvdwh_orders_pkg.summarise_orders'; LET vFlagContent = FieldValue('LOG_SUCCESS', 1); // there must be only one record fetchedIF $(vFlagContent) = 'Y' THEN STORE FlagTable INTO Flag.qvd; DROP TABLE FlagTable; LOAD * FROM Flag.qvd (qvd);END IF

Hope that helps.

EDIT: revised code