QlikView documentation and resources.
Step 1) First schedule a task in QMC to reload your document. The task should be triggered "on an external event". It will be just waiting for a signal (see fig 1)
Fig 1
Then type a password for this task (you will need to use this password as an argument in the command line to trigger the task ) ( See fig 2) ,save it ,then apply
Fig 2
2) Download the Enhanced version of QlikTech QMSEDX program from here and save it on your system or the QV server box.
3) Now type the command to trigger the task from command line in a text file and save it as a bat file (you can convert a .txt file into bat file by changing the file extension to .bat) in the same location as that of the downloaded . The syntax of the command is as follows:
QMSEDX.exe -task="NameOfTheTask " -qms="NameOfTheQVServerBox" -password="PasswordOfTheTask"
Note: If the executables are present in a different location then tweak the command like this
"PathOfTheFolder\QMSEDX.exe"-task="NameOfTheTask " -qms="NameOfTheQVServerBox" -password="PasswordOfTheTask"
4) Name of the task can be found here (See fig 3 )
Fig 3
You can find the name of the computer (it has to be the name of QV server box ) by right clicking on My Computer icon ,click properties .
You can find the password here (see fig 4)
Fig 4
Note : You may have to unblock the executable (By checking the Properties of QMSEDX.exe. file )
.
Thank you for the post;
To use QMS-EDX, is it essential to have a Publisher License or this could be done with a QlikView Server?
Thanks,
Omar,
you are welcome,publisher( or 3rd party scheduler) is needed for scheduling tasks on QMC
So, if I select "by an external event" and use a .bat file for example to run my task; I don't have to use publisher?
Thanks, it is useful
Hi,
Can i Use QMSEDX without marking Trigger by External event. ? I've task (task2) which will trigger on the success of its dependent task(task1). So I need to trigger the dependent task first.
I do not want to choose Trigger on external event for task1. Is it possible ?
Where can I find the latest version of QMSEDX? The link in this thread no longer works.
Hi Swarup,
i am new to qlikview and i read your document.
i have ETL job and an application in qlikview and i want to run the qvw after the ETL job completed successfully . so i understand the qlikview part from document how i have to configure but i just want to know how do i trigger the .bat file once my ETL job completed successfully.
if you could share any information it would be great!
Regards,
Vijay Kumar