Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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

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.

Not applicable

Hi,

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