Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to call QV.exe from SQL server Agent ?

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.

3 Replies
Highlighted
Partner
Partner

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

Highlighted
Not applicable

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.

Highlighted
Not applicable

Hi,

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