topic Re: QlikView Batch Jobs execution using CONTROL-M in QlikView

QlikView Batch Jobs execution using CONTROL-M

PradeepReddy — Mon, 09 Nov 2015 10:19:50 GMT

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

Re: QlikView Batch Jobs execution using CONTROL-M

Anonymous — Mon, 09 Nov 2015 10:27:37 GMT

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

Re: QlikView Batch Jobs execution using CONTROL-M

sasikanth — Mon, 09 Nov 2015 10:37:59 GMT

HI,

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

Any thoughts on the same?

Re: QlikView Batch Jobs execution using CONTROL-M

Anonymous — Mon, 09 Nov 2015 10:40:38 GMT

Using EDX in QlikView 11 - basic example

What about this?

Re: QlikView Batch Jobs execution using CONTROL-M

Anonymous — Mon, 09 Nov 2015 10:41:44 GMT

How to trigger QMC tasks without QMC scheduling

Re: QlikView Batch Jobs execution using CONTROL-M

marcus_sommer — Mon, 09 Nov 2015 10:53:06 GMT

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

Re: QlikView Batch Jobs execution using CONTROL-M

PradeepReddy — Mon, 09 Nov 2015 11:11:06 GMT

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

Re: QlikView Batch Jobs execution using CONTROL-M

marcus_sommer — Mon, 09 Nov 2015 11:45:59 GMT

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

Re: QlikView Batch Jobs execution using CONTROL-M

PradeepReddy — Mon, 09 Nov 2015 12:39:34 GMT

Thanks Marcus, will check the settings once again

Re: QlikView Batch Jobs execution using CONTROL-M

Anonymous — Fri, 17 Mar 2017 16:23:10 GMT

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

Regards