Disable tasks in a specific period of day

[fernandotoledo]

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

[#2]

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,

[#3]

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 · Accepted solution]

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]

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

[#6]

check this to see how to set it using publisher

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

[fernandotoledo]

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