Trigger a QV Server job from SQL Server

[paul_scotchford]

Hi All

I would like to trigger a QV Task on our QlikView production server when a SQL task on our Production BI Server has completed.

The QV server and SQL Server are two separate servers, hence the trigger will be across the network.

I guess I would like a command line that can be executed from CmdExec in SQL, I first experimented with the below cmd

C:\Program Files\QlikView\qv.exe qvp://ServerName\AccountName@url/AQVDGenerator.qvw

Of course this does not work as it wants a password for the executing account and I don't want to parse

(assuming you can) a password in cleartext across the network.

Has anyone had experience using this technique to trigger QV jobs?

Thanks in advance

Paul

[Clint_Carr]

Hi Paul,

I recommend you read the following:

Using EDX in QlikView 11

Kind Regards,

Clint

[paul_scotchford]

Thanks Clint, I'll read up on EDX

Cheers

Paul

[Clint_Carr · Accepted solution]

.Hi Paul,

An alternative is to create a batch file and reference the following:

"C:\Program files\QlikView\Distribution Service\QVDistributionService.exe" -r="C:\<location of qvw file"

You will need to edit the file c:\program files\qlikview\distribution service\QVDistributionService.exe.config

Look for EnableBatch,  set to True.

The user account running the batch needs to be a member of the QlikView Administrators group.

[paul_scotchford]

Thanks Clint, I got a working solution done.

Cheers

Paul