Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fernandotoledo
Partner - Specialist
Partner - Specialist

Disable tasks in a specific period of day

Hi everybody,

Is there a way to prevent tasks from executing in specific period of time, like from X to Y hour every day?

My database becomes unavailable for two hours every day, and I would like to turn off the tasks that runs in this period of the day.

Thanks,

Fernando

1 Solution

Accepted Solutions
mike_garcia
Luminary Alumni
Luminary Alumni

How about using an IF Statement in your script and play with your time range. IF the script is being called (use Now(1)) during the time out period, THEN skip everithing and exit the script.

That should work if the task is generating QVD files, because the final app would still use the already generated files.

Regards,

Mike.

Miguel García
Qlik Expert, Author and Trainer

View solution in original post

6 Replies
Not applicable

Hi,
Please let me know if you get the solution.
My requirement is quite similar as yours.
I need to disable the task only when there is 0 record in my qvds for which task is defined.

Thanks,

Not applicable

Hi,
Please let me know if you get the solution.
My requirement is quite similar as yours.
I need to disable the task only when there is 0 record in my qvds for which task is defined.

Thanks,

mike_garcia
Luminary Alumni
Luminary Alumni

How about using an IF Statement in your script and play with your time range. IF the script is being called (use Now(1)) during the time out period, THEN skip everithing and exit the script.

That should work if the task is generating QVD files, because the final app would still use the already generated files.

Regards,

Mike.

Miguel García
Qlik Expert, Author and Trainer
fernandotoledo
Partner - Specialist
Partner - Specialist
Author

Thanks Mike,

This is a great idea! I think that, if there is no way of doing this in the Publisher, it´s the best solution so far.

But I still would like like to know how to do it through the Control Panel...

Any idea?

Best regards

Fernando

Not applicable

check this to see how to set it using publisher

http://community.qlik.com/forums/t/25267.aspx

fernandotoledo
Partner - Specialist
Partner - Specialist
Author

The result is:

1) There is a way to do this in the Source Documents Tab, with the field "Run Betwen". But only if you have a Publisher Licence. Not my case, we have only QVServer.

2) You can use a script "Skip" line if the time is in that interval that the DB is unavailable.

3) You can use the command line to create a .Bat (like in the old times) and the windows scheduler.

I´d rather go with (2)

Thank´s everybody!

Fernando