QlikView Batch Jobs execution using CONTROL-M

[PradeepReddy]

Hi,

I want to execute the QlikView Batch Jobs using 3rd party tool CONTROL-M.

some inputs for understanding purpose..

1) We are not using QlikView Publisher

2) QlikView batch job execution depends on the ETL batch Job status.  On successful of ETL job only, QlikView job should trigger.

3) Whenever I execute the Batch Jobs manually, they are working fine. But not able to trigger the same applications using CONTROL-M.

4) We have tried using EDX triggers as well, but no luck. Might be missing some thing.

Can anyone please share your thoughts, approaches on the same.

Thanks,

Pradeep

[Anonymous]

This might be useful for you:

Running Qlikview document with macros as scheduled task without being logged on

Reloading data into Qlikview using a schedule

[sasikanth]

HI,

we want to trigger the tasks though CONTROL M not with Windows ,

Any thoughts on the same?

[Anonymous]

Using EDX in QlikView 11 - basic example

What about this?

[Anonymous]

How to trigger QMC tasks without QMC scheduling

[marcus_sommer]

You don't need compelling the publisher to trigger reload-tasks within the qmc - with a normal server it's also possible (not quite so flexible - but possible).

If this isn't suitable enough you should rather use vbs-macros instead of batch-files especially if you need to consider various dependencies like day of month, weekday, certain data are available/updated, other successfully loaded tasks and so on which could be mostly included into these vbs-routines.

The main advantage from vbs against batch-files is the flexibility and to trigger one or maybe a few such vbs-routines could be easily done with qlikview or windows - no need for a third party tool.

Re: Vbs - passing parameters to opendoc or opendocex

- Marcus

[PradeepReddy]

Hi Marcus,

Thanks for reply. Actually we are executing lot of upstream applications using CONTROL-M tool.  Each application is dependent on its previous application/job.

In simple words dependency flow... Upstream Application Jobs--> ETL Jobs --> QlikView Jobs.

If there is no any dependency on upstream application and ETL Jobs, we would use QMC Scheduler.

Thanks,

Pradeep

[marcus_sommer]

I don't know CONTROL-M and it's capability to trigger batch-files within the windows file-system - maybe there must be something (differently) configurated. I think more likely is that the access rights to the batches aren't properly and/or they will be blocked from any security-mechanism - for this you should have a look on the windows event-logs.

- Marcus

[PradeepReddy]

Thanks Marcus, will check the settings once again

[Anonymous]

Hello pradeep, were you able to run a QMC task with Control-M? What was your solution?

Regards