topic Re: How to schedule the Batch file in QMC in QlikView

How to schedule the Batch file in QMC

ravindraa — Thu, 01 Jan 2015 10:37:58 GMT

Hi all,

I have 2 application one is ETL and another one is Application, in the appliction i wrote Macro to send the Mails to the users.

the problem is QMC is not supporting the MACRO'S.. i mean it is not sending the mails , but if i trigger the appliction through batch file it is sending the Mails.

but if i schedule Batch file through windows schedule, the appliction is reloading irrespective of ETL reload, i need to run the Batch file after reloading the ETL.

if ETL is not reload at perticular day the Batch file shouldshould not be reload.

and can we reload the Batch file in QMC.

please give me any suggession on this.

thanks in advance.

Re: How to schedule the Batch file in QMC

jjordaan — Thu, 01 Jan 2015 11:30:58 GMT

Hi Ravindraa,

As far as I know you cannot schedule bat files through the QMC.

However you can execute EDX triggers.

See this post http://community.qlik.com/docs/DOC-3024

Re: How to schedule the Batch file in QMC

udit_kumar_sana — Thu, 01 Jan 2015 13:36:08 GMT

Hi,

You can use an new .qvw file with below script having path of your bat file in double quotes:-

EXECUTE cmd.exe /c "path\.bat";

This .qvw file will execute your .bat file.

Then u can schedule this .qvw file from QMC .

In order to reload the bat file after reloading ETL,schedule this .qvw file under ETL task on condition of successful reload.

Thanks & Regards,

Udit

Re: How to schedule the Batch file in QMC

ravindraa — Fri, 02 Jan 2015 06:01:01 GMT

Hi Udit Sandhya,

thanks for giving suggesion but i have created application usining EXECUTE function , but while reloading the application it is asking below options .

plese give me any suggestion to set bydefult "Override Security Execute This Statement " option.

Re: How to schedule the Batch file in QMC

vikasmahajan — Fri, 02 Jan 2015 06:30:02 GMT

Tick on can execute external progs please see attached file.

vikas

Re: How to schedule the Batch file in QMC

udit_kumar_sana — Fri, 02 Jan 2015 06:45:37 GMT

follow Vikas Step, you should get it done

Re: How to schedule the Batch file in QMC

ravindraa — Fri, 02 Jan 2015 07:25:17 GMT

Hi Vikas,

thanks for giving suggession after click that option it is showing below settiong options plese give me any sugesstions.

plese find below screen shot.

please give suggession.

Re: How to schedule the Batch file in QMC

ravindraa — Fri, 02 Jan 2015 08:21:47 GMT

Hi Udit Sandhya,

Please give me any suggesion .

Re: How to schedule the Batch file in QMC

Anonymous — Fri, 02 Jan 2015 09:39:26 GMT

Hi,

You can create a batch file and run it through external task tab on QMC.

Then you can run this task on success of another task, the option is availble on the same tab.

HTY

Re: How to schedule the Batch file in QMC

udit_kumar_sana — Fri, 02 Jan 2015 11:49:30 GMT

In Macro Edit Module Of .qvw file select request mode security and current mode security to:-System access