Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

fernandotoledo
Valued Contributor

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
Contributor III

Disable tasks in a specific period of day

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.

6 Replies
Not applicable

Disable tasks in a specific period of day

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

Disable tasks in a specific period of day

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
Contributor III

Disable tasks in a specific period of day

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.

fernandotoledo
Valued Contributor

Disable tasks in a specific period of day

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

Disable tasks in a specific period of day

check this to see how to set it using publisher

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

fernandotoledo
Valued Contributor

Disable tasks in a specific period of day

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