topic Publisher-task with trigger on an External event in QlikView https://community.qlik.com/t5/QlikView/Publisher-task-with-trigger-on-an-External-event/m-p/10903#M1724 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Could you help me find some solution.</P><P></P><P>I would like run QlikView task from MS SQL by last job step. How i can do it? Anyone help??</P><P></P><P>I found some solution but dont know how prepare it...</P><P></P><P>1) On SQL Server(X) i create job and last step launch .bat file (this batch launch task on QV server)</P><P>2) On QlikView Server (Server Y) I create Task with trigger on an external event</P><P></P><P></P><P>My Question:</P><P>How .bat file should looks (whats the structure of batch file to launch QV task?</P><P>Batch file exists on sql server, so sql server should has access to QV Server (other server)?</P><P>Task build in QMC with trigger on an external events need some password. Can I set empty password?? if i cant how i can set password in .bat file?</P></BODY></HTML> Mon, 12 Mar 2018 10:30:05 GMT ambasadorknz 2018-03-12T10:30:05Z Publisher-task with trigger on an External event https://community.qlik.com/t5/QlikView/Publisher-task-with-trigger-on-an-External-event/m-p/10903#M1724 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Could you help me find some solution.</P><P></P><P>I would like run QlikView task from MS SQL by last job step. How i can do it? Anyone help??</P><P></P><P>I found some solution but dont know how prepare it...</P><P></P><P>1) On SQL Server(X) i create job and last step launch .bat file (this batch launch task on QV server)</P><P>2) On QlikView Server (Server Y) I create Task with trigger on an external event</P><P></P><P></P><P>My Question:</P><P>How .bat file should looks (whats the structure of batch file to launch QV task?</P><P>Batch file exists on sql server, so sql server should has access to QV Server (other server)?</P><P>Task build in QMC with trigger on an external events need some password. Can I set empty password?? if i cant how i can set password in .bat file?</P></BODY></HTML> Mon, 12 Mar 2018 10:30:05 GMT https://community.qlik.com/t5/QlikView/Publisher-task-with-trigger-on-an-External-event/m-p/10903#M1724 ambasadorknz 2018-03-12T10:30:05Z