Restart failed jobs

[kris_vliegen]

Hi All,

I have some reloadjobs that load data of a server from a customer.

The connection between the qlikview-server and the data-server is not always online.

I have to reload 6 qvd's and a dashboard once a day.

It starts at 6 AM and sometimes the connection is offline and the reload fails.

But sometimes the 1st one reload succesfull and the second one fails.

Is there any mechanism to reschedule till the dashboard is loaded that day?

I can schedule the reload every hour and put this in the beginning of reloadscripts to create the qvd's.

let vReload = date(filetime('..\04_Documents\Dashboard.qvw'));

let vToday = Date(Now());

if($(vReload) =$(vToday)  ) THEN

exit script;

ENDIF;

But then the dashboard reload every hour and this is not the thing I wan't.

And If I put the same script in the reloadscript of the dashboard, an empty dashboards is what I get.

Who can help me with this?

Regards,

Kris

[rwunderlich]

Do you have Publisher? If so, set the "number of retries" in the task definition.

-Rob

[kris_vliegen]

Hi,

Can I set this to 100? Because sometimes the connection is lost for an hour?

Regards,

Kris

[rwunderlich · Accepted solution]

The Help for the "Number of tries" field does not indicate any limit.  You should be able to enter 100 or more tries.

-Rob

[kris_vliegen]

Ok, I will try this.

Is there a pause between de tries?

[rwunderlich]

I don't believe there is any pause. You could build a pause into the the beginning of your script with the SLEEP statement.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com