topic How to call QV.exe from SQL server Agent ? in QlikView

How to call QV.exe from SQL server Agent ?

Wed, 10 Feb 2010 00:40:11 GMT

How can I call QV.exe from Microsoft SQL Server 2005 - > SQL Server Agent to reload the Qlikview file ?

I have a 1 liner command in test.bat Batch file as below :-

"C:\Program Files\QlikView\Qv.exe" /r "C:\Temp\test.qvw"

It runs fine when I double click to run the .bat file but if calling the batch file via CmdExec from SQL Server Agent (SQL Server 2005) it just launch the process but doesn't do anything else.

How to call QV.exe from SQL server Agent ?

disqr_rm — Wed, 10 Feb 2010 02:02:07 GMT

Did you set permissions correctly for the user running this job? Have a look here http://www.lazydba.com/sql/1__8280.html

Hope this resolves your problem.

Rakesh

How to call QV.exe from SQL server Agent ?

Wed, 10 Feb 2010 04:03:17 GMT

I doubt the permission is the issue here.

When I replaced the command into running 'echo' command it works fine.

When I try to call QV.exe from the same .bat file, however, the QV.exe is launched as can see in Task Manager, but just sat there.

Re: How to call QV.exe from SQL server Agent ?

Thu, 07 Aug 2014 14:05:59 GMT

Hi,

i've got the same problem in sql server agent 2012. Someone have solved and fixed this problem?