Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

QlikView Batch Jobs execution using CONTROL-M

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

9 Replies
Highlighted
Champion
Champion

Re: QlikView Batch Jobs execution using CONTROL-M

Highlighted
Specialist III
Specialist III

Re: QlikView Batch Jobs execution using CONTROL-M

HI,

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

Any thoughts on the same?

Highlighted
Champion
Champion

Re: QlikView Batch Jobs execution using CONTROL-M

Highlighted
Champion
Champion

Re: QlikView Batch Jobs execution using CONTROL-M

Highlighted
MVP & Luminary
MVP & Luminary

Re: QlikView Batch Jobs execution using CONTROL-M

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

Highlighted
Specialist II
Specialist II

Re: QlikView Batch Jobs execution using CONTROL-M

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: QlikView Batch Jobs execution using CONTROL-M

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

Highlighted
Specialist II
Specialist II

Re: QlikView Batch Jobs execution using CONTROL-M

Thanks Marcus, will check the settings once again

Highlighted
Contributor III
Contributor III

Re: QlikView Batch Jobs execution using CONTROL-M

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

Regards