topic Re: Macro Question on schedular in QlikView

Macro Question on schedular

vikasmahajan — Thu, 28 Mar 2013 04:32:10 GMT

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

Re: Macro Question on schedular

rwunderlich — Thu, 28 Mar 2013 05:43:22 GMT

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

Re: Macro Question on schedular

vikasmahajan — Thu, 28 Mar 2013 06:03:12 GMT

Dear Sir,

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

Vikas

Re: Macro Question on schedular

vikasmahajan — Thu, 28 Mar 2013 06:03:33 GMT

Dear Sir,

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

Vikas

Re: Macro Question on schedular

vikasmahajan — Thu, 28 Mar 2013 07:53:20 GMT

Dear Sir

I am awating for your feedback.

Thanks

Vikas

Re: Macro Question on schedular

Thu, 28 Mar 2013 09:06:27 GMT

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

Re: Macro Question on schedular

vikasmahajan — Thu, 28 Mar 2013 09:16:33 GMT

can u Please explain with details ?

Re: Macro Question on schedular

Thu, 28 Mar 2013 09:41:02 GMT

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

Re: Macro Question on schedular

vikasmahajan — Thu, 28 Mar 2013 12:40:23 GMT

I created batch file but where is external task option ?

Please refer screen short I have attach 1u.jpg

Thanks

Vikas

Re: Macro Question on schedular

Thu, 28 Mar 2013 13:14:43 GMT

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

Re: Macro Question on schedular

vikasmahajan — Fri, 29 Mar 2013 07:01:16 GMT

I am Using version 11 not found this option ?

Is it available in 11

Also Please explain windows tasks how to schedule with screen shots how to check ? when job is finished ?

Thanks

Vikas

Re: Macro Question on schedular

Fri, 29 Mar 2013 07:31:10 GMT

Hi,

Its avaible on QVS 11, maybe it requires publisher license (which I am not sure).

You can use windows task scheduler (available on windows server) also to schedule the batch file.

Actually i dont have windows server so wont be able to give you screen shots.

Its simple process, just open the task scheduler and add new task, give the specific time for when to reload the task, add the batch to the task and your task will be created.

Regards,

Amay

Re: Macro Question on schedular

vikasmahajan — Fri, 29 Mar 2013 12:08:20 GMT

Thanks for detail explanation

Bye

Vikas

Re: Macro Question on schedular

vikasmahajan — Sat, 30 Mar 2013 04:30:28 GMT

Rob Sir,

Thanks for your valuable input as per Mr.Amay Patil Suggessions I am Creating batch file and will try to schedule through windows schedular

Vikas