Exit script on day's specified in qvd

[Erik6]

Hi,

My reload script is scheduled to run every workday. But it must not run on certain day's. These day's are specified in a qvd.

I've the feeling that I should use the exist() function, but I don't know how to solve this.

[Erik6 · Accepted solution]

I've found a solution:

Holidays:

LOAD
HolidayYear,
Concat(HolidayDate,',') as ListOfHolidays
FROM (qvd)
Where
HolidayYear =Year(Today())
Group By HolidayYear;

LET vCheck= Peek('ListOfHolidays',0,'Holidays');
LET vToday=Today()+0;  //the +0 converts the date into a datenumber, quick/dirty.
DROP Table Holidays;

If Wildmatch($(vToday),$(vCheck))<>0 then
EXIT SCRIPT;
ELSE
//do your coding
ENDIF