Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Scheduler question

Hi all

My document is set to reload every hour of every day. A reload lasts 30-40 minutes.

Because of recent changes to our servers I need to set a gap between the hours 00:00 AM and 04:00  AM where data should NOT be read.

The scheduler in the Management Console does not allow for that.

Any suggestions?

Tried to capture the numeric value of the time the script starts like so :  

NUM(Date(Now(),'HH:MM:SS'))
But that returns the numeric value of the whole date and not just the time.

Thanks all

Stay safe.

1 Solution

Accepted Solutions
Highlighted

Re: Scheduler question

Hi, you can check Hour using Hour(Now()) and mix with an IF clause at start that executes an "exit script;" when it's not loading hours.

Another option is using an external scheduler with EDX:

https://community.qlik.com/t5/QlikView-Documents/Using-EDX-in-QlikView-11/ta-p/1478952

https://community.qlik.com/t5/QlikView-Documents/Using-EDX-in-QlikView-11-basic-example/ta-p/1494384

View solution in original post

2 Replies
Highlighted

Re: Scheduler question

Hi, you can check Hour using Hour(Now()) and mix with an IF clause at start that executes an "exit script;" when it's not loading hours.

Another option is using an external scheduler with EDX:

https://community.qlik.com/t5/QlikView-Documents/Using-EDX-in-QlikView-11/ta-p/1478952

https://community.qlik.com/t5/QlikView-Documents/Using-EDX-in-QlikView-11-basic-example/ta-p/1494384

View solution in original post

Highlighted
Specialist
Specialist

Re: Scheduler question

Thank you Ruben. Meanwhile I came up with the same idea and If...End If solution. It works!