topic Re: Trigger a QV Server job from SQL Server in QlikView

Trigger a QV Server job from SQL Server

paul_scotchford — Tue, 08 Jul 2014 06:11:06 GMT

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 — Tue, 08 Jul 2014 06:14:23 GMT

Hi Paul,

I recommend you read the following:

Kind Regards,

Clint

paul_scotchford — Sun, 13 Jul 2014 22:06:30 GMT

Thanks Clint, I'll read up on EDX

Cheers

Paul

Clint_Carr — Mon, 14 Jul 2014 00:16:43 GMT

.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 — Mon, 14 Jul 2014 01:10:24 GMT

Thanks Clint, I got a working solution done.

Cheers

Paul