Solved: Macro Question on schedular - Qlik Community

vikasmahajan · ‎2013-03-28

Dear All

I have written macro for sending emails to users and after reload action send reports to user's

Please refer attachment of my file in macro_question.jpg , After reload email is not going to

user in jpg I have set setting.

What could be a problem ? any idea ? Why this email is not going to user , When i run macro manually it is going but not from schedular ?

Thanks in advance

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.

Report Inappropriate Content · ‎2013-03-28

Hi,

On QMC-->System, you will have supporting tasks tab, this tab will contain the External programs option in that you will be able to schedule the external tasks.

Which version of Qlikview server are you using? also, do you have publisher license?

Regards,

Amay

View solution in original post

rwunderlich · ‎2013-03-28

1. You can't get system access for a server reload.

2. I don't think server reloads even run the OnPostReload action.

Others have worked around this by running a command line reload.

-Rob

vikasmahajan · ‎2013-03-28

Dear Sir,

Thanks for reply can u explain how to achive the using command line realod ?

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.

vikasmahajan · ‎2013-03-28

Dear Sir,

Thanks for reply can u explain how to achive the using command line realod ?

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.

vikasmahajan · ‎2013-03-28

Dear Sir

I am awating for your feedback.

Thanks

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.

Report Inappropriate Content · ‎2013-03-28

Hi,

You have to write a batch file for reloading the application.

Then you need to run this batch through external tasks on QEMC-->System

Hope this helps.

Regards,

Amay

vikasmahajan · ‎2013-03-28

can u Please explain with details ?

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.

Report Inappropriate Content · ‎2013-03-28

First you need to write a batch file

Open a notepad, write the below command line and save it as .bat file

"C\Program files\Qlikview\QV.exe" \r "(Path of your doument)\(Document name)"

Exit

Try running the bat file manually and check if your able to run the application.

Then you can go to QEMC --> System --> External tasks in that add a new task and give the path of the bat file and schedule it as per ur requirment.

Regards

Amay

vikasmahajan · ‎2013-03-28

I created batch file but where is external task option ?

Please refer screen short I have attach 1u.jpg

Thanks

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.

Report Inappropriate Content · ‎2013-03-28

Hi,

On QMC-->System, you will have supporting tasks tab, this tab will contain the External programs option in that you will be able to schedule the external tasks.

Which version of Qlikview server are you using? also, do you have publisher license?

Regards,

Amay

Macro Question on schedular

QlikView App Dev