topic Re: Qlikview refresh - run everyday except sundays? in QlikView

Qlikview refresh - run everyday except sundays?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi there experts,

My refresh runs everyday at 12 am. But it conflicts with server maintenance every Sunday. So is there a way to schedule refresh everyday except Sundays? Or shift the refresh timing on Sundays to 2 am instead?

Help appreciated! Thank you!

Regards,

Benazir

Re: Qlikview refresh - run everyday except sundays?

mdmukramali — Sat, 21 Jul 2018 10:28:22 GMT

Hi Benazir,

Do you have Publisher ?

or else you can try the below script beginning of the QVW file.

if match(weekday(today()), 'Sun') then

exit script;

end if

// Script.

Re: Qlikview refresh - run everyday except sundays?

BalaBhaskar_Qlik — Sat, 21 Jul 2018 10:42:03 GMT

Think so, create dependent task for Sunday at 2AM.

Re: Qlikview refresh - run everyday except sundays?

pooja_prabhu_n — Mon, 23 Jul 2018 05:13:58 GMT

Hi,

In QEMC triggers you can select all the days except Sunday.

Thanks,

Pooja

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 05:51:09 GMT

Thank for your inputs everyone! I'm going to try these and get back.

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 06:17:30 GMT

Hi Pooja,

I'm using QMC and unfortunately can't find this setting at all. My weekly trigger allows me to select only one day of the week - in a drop down.

Rgds,

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 06:19:09 GMT

I don't have publisher. But I think the exit script may work for me!! thanks for the idea - I will try this out and get back

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 06:34:25 GMT

Can you perhaps explain a little more? How I go about creating a Dependent Task?

Re: Qlikview refresh - run everyday except sundays?

pooja_prabhu_n — Mon, 23 Jul 2018 06:44:55 GMT

Hi Benazir,

In weekly trigger you can select more than one day of the week.

Thanks,

Pooja

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 08:22:12 GMT

This is what I see - what version are you on?

Re: Qlikview refresh - run everyday except sundays?

mdmukramali — Mon, 23 Jul 2018 08:36:19 GMT

Hi,

it seems you don't have Qlikview Publisher

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 08:50:10 GMT

Yep. That's what I've stated - no publisher. I'm trying Sleep function in your "If script" - but I'm wondering if that'll be ineffective considering the server restarts during maintenance!

Re: Qlikview refresh - run everyday except sundays?

jonathandienst — Mon, 23 Jul 2018 08:51:31 GMT

Scheduling without Publisher is very basic. You would be get the best results with the Exit Script approach above.

Re: Qlikview refresh - run everyday except sundays?

Anonymous — Mon, 23 Jul 2018 09:01:17 GMT

Precisely - I'm trying a Sleep function on the script - will update how it goes