topic Re: QMC failed job auto restart in QlikView

QMC failed job auto restart

shanu_s9 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i hope some one will assist on my issue.

We have some jobs scheduled in the QMC, it is updating once in a day. the jobs are running around 2 AM, if any job failed, it has to restart after 15 mins automatically.

Is there any way or any mechanism to implement.

Many thanks.

Re: QMC failed job auto restart

shiveshsingh — Mon, 12 Mar 2018 15:12:56 GMT

At the beginning of the load script you could put a sleep()

Refer

Restart failed and not executed QMC tasks with the QMSEDX interface.

Re: QMC failed job auto restart

shanu_s9 — Tue, 13 Mar 2018 11:51:48 GMT

Thanks Shivesh for your help.

i found another option, in triggers Number of tries, But this is restarting the job immediately, when job failed.

Do we have any option, When job failed, next occurrence would start after some time like 15 minutes.

Please assists.

Re: QMC failed job auto restart

Peter_Cammaert — Tue, 13 Mar 2018 11:57:31 GMT

I think there is no solution that handles all possible causes of server reload failure. For example, a sleep() call at the beginning of your load script may be ideal to give a database connection time to become stable again, but wouldn't help if your reload fails because there are no engines available for at least 45 mins.

Care to provide some more details about why this task is failing?

Re: QMC failed job auto restart

shiveshsingh — Tue, 13 Mar 2018 16:27:13 GMT

That's why, after doing this configuration in QMC, you can put sleep() to delay the retry, but why you rjob is failing? any specific reason?