Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

dmohanty
Valued Contributor

How to create trigger for multiple frequency reload?

Hi All,

My requirement is to set some QVWs for multiple relaod at different hours in a day. Suppose one QVW has to run at 6:30AM,11:00AM, 3:35PM, 9:55PM.

I am able to set a single time for reload. How to set this multiple time in triggers?

Regards!!!

1 Solution

Accepted Solutions

Re: How to create trigger for multiple frequency reload?

Sorry, it took a while since i have no publisher on my laptop.

Irregular intervals = create 4 weekly triggers, that's the simplest solution

Add a trigger, configure as Weekly, set start date&time on today 6:30AM and select the weekdays on which you fire this trigger

WT1 Dialog.jpg

Create 3 more triggers in the same wayt, until you have this:

WT2 Dialog.jpg

(The last line is of course incomplete, had to leave this QMC in a hurry)

Job done.

Peter

11 Replies
Not applicable

Re: How to create trigger for multiple frequency reload?

Hi,

On server you will have option to set it up to run for every hour or as per your requirement.

Regards,

Amay.

dmohanty
Valued Contributor

Re: How to create trigger for multiple frequency reload?

Ok I understand....But where to set the specific timings exactly in the Triggers tab.

There are options Daily, Hourly, Weekly etc. Suppose i go into Hourly Tab, then where to set my 4 timings for a day. Could you please post a screenshot?

Not applicable

Re: How to create trigger for multiple frequency reload?

In hourly tab you can give the trigger to run it for every 4 hours or so...and enable it to run between specific timings only ( 6:30 AM to 9:55 PM ).

As of now I don't have server, so cant post screen shot..Smiley Sad

Regards,

Amay

dmohanty
Valued Contributor

Re: How to create trigger for multiple frequency reload?


Hi Amay,

Can we give the exact multiple timings we want?

Re: How to create trigger for multiple frequency reload?

If you have a publisher and you want to run a task multiple times, but the moments have varying intervals (not every 40 minutes, but rather after 4h30m, then after 4h35, etc. like in your example) you define multiple single instance triggers.

Just let each one of them fire at a specific time of day and only once by setting the window ("Run only between...") to something small..

If you don't have a publisher, try to reload at fixed intervals, or use an external triggering source (EDX).

Best,

Peter

dmohanty
Valued Contributor

Re: How to create trigger for multiple frequency reload?


HI Peter,

Thanks for response.
I have a publisher to reload the QVD generator. Can you please post a screesnhot of the trigger tab using the timings I mentioned above on how to set this?

Not applicable

Re: How to create trigger for multiple frequency reload?

Hi,

I think u have to add separate task for each time to reload, because your timings are nor regular intervals.

If its regular intervals than you can keep only one task, if its not regular interval, you may need to add separate task for separate timings to reload the application.

dmohanty
Valued Contributor

Re: How to create trigger for multiple frequency reload?

OK...For irregual intervals I am clear how to create different tasks.

Suppose for regular intervals(let say 3hr or 4hr), could you please show me a screenshot for a single task?

Not applicable

Re: How to create trigger for multiple frequency reload?

goto Documents -> Source Documents ->select the document ->add task(using + button) -> Triggers - > add task( using +button) - > on a Schedule select the hourly option then you can see each hour or u can specify 3 hrs once and also if u want u can mention repeat reload task between 6AM to 6PM.