topic Re: Issue in Scheduling in QlikView

Issue in Scheduling

Sun, 08 Jul 2012 06:38:04 GMT

Hello QV Experts ,

I have an Issue with Scheduling , Let me explain it breifly

In My Current Scenario i have four applications..

Lets say A,B,C,D

First A gets loaded which is a QVD builder , On success of A B,C,D are parallelly getting started.

The issue here is some time's the Jobs any one of B or C or D are getting failed and some times are the thre Applications are getting failed.

The issue here is All the three applications are hitting a QVD at the same time which was built in A.

Now I need re schedule it in such a way that

After completion of A B should start and after 10 mins of B's Run C should start and after 10 mins of C's Run D should run.

Attached is the Log of recent failures..

Is this possible with QV Scheduler.

We have Publisher License as well..

Highly appreciate your help

Re: Issue in Scheduling

magavi_framsteg — Mon, 09 Jul 2012 08:28:08 GMT

Hi NIRAJ.

Yes you can (in a way) by using external pause tasks.

I think this is in QMC > System > External, I don't have access to a QVP right now, but you can search the QVP refman for external task or pause task or something.

Anyway when you find it, create two external pause tasks and make them pause 10min.

ie:

PauseBStart

PauseCStart

Set the normal schedule for A.

When A is succeeds, start B and PauseBStart.

When PauseBStart succeeds, start C and PauseCStart.

When PauseCStart succeeds, start D.

Hope this helps, if so, please mark the question as answered for others to take benefit of the solution.

Cheers!

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Issue in Scheduling

Thu, 12 Jul 2012 14:39:17 GMT

Hi Magnus,

Sorry for the delay in responding,was little busy .

Thank you so much the info provided.

Its great to know that my task can be achievable.

Can you please elaborate on how to create Pause Tasks and where to call , also if possible attach a sample PauseTask application.That will be a great help for me.

Thanks

Re: Issue in Scheduling

magavi_framsteg — Fri, 13 Jul 2012 09:46:59 GMT

Hi again, and no problem for the delay 😃

A Pause Task is not an application.

It is a task designed to pause x seconds.

Other than that it works exactly like the standard document tasks, and they can be triggered the same way.

You can configure them here:

QMC > System > Supporting Taks

- External Program - Run Windows batchfiles (.bat / .cmd) and such

- Pause - Task with the purpose of pausing X seconds

- QVD Creation - Supply script for creating QVD without the need of an underlying QVW

QVD Creation tasks are, in my opinion and experience, not recommended since they will be contained in the QVP database and thus will be more difficult to maintain.

Please see my screenshot below:

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Issue in Scheduling

Sat, 14 Jul 2012 11:04:58 GMT

Thank you Magnus..

Working fine.

Re: Issue in Scheduling

Sat, 14 Jul 2012 23:06:09 GMT

Why use a Pause task?

My approach would be either to let B start on succes with A, and C start on succes with B, and D start on succes with C.

Or you could let A create 3 qvd. Done by 3 statements in the load script. One for each of the following apps.