How to schedule the Batch file in QMC - Qlik Community

ravindraa · ‎2015-01-01

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.

jjordaan · ‎2015-01-01

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

udit_kumar_sana · ‎2015-01-01

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

ravindraa · ‎2015-01-02

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.

vikasmahajan · ‎2015-01-02

Tick on can execute external progs please see attached file.

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

udit_kumar_sana · ‎2015-01-02

follow Vikas Step, you should get it done

ravindraa · ‎2015-01-02

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.

ravindraa · ‎2015-01-02

Hi Udit Sandhya,

Please give me any suggesion .

Anonymous · ‎2015-01-02

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

udit_kumar_sana · ‎2015-01-02

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