Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

get jobs status on QlikView Publisher 11.2

Hi all!

is there a function or sql command line or a batch file... that returns 0 or 1 depending on the status (success or failure) of the jobs on QlikView Publisher ? (screenshot)

I need to get the result on a remote computer.

error.png

5 Replies
Not applicable

Re: get jobs status on QlikView Publisher 11.2

QMS API will provide that funtion for you

From refman 11.20:

Starting an EDX returns a session ID to allow interrogation of the status of the session rather than on the task. When the session is done, the status contains a list of all the tasks (and session IDs) that have been triggered, allowing for continuous tracking of the status. This functionality is available through the API.

Not applicable

Re: get jobs status on QlikView Publisher 11.2

How to get the status of the session with EDX ? is there an example?

Not applicable

Re: get jobs status on QlikView Publisher 11.2

Examples are installed when you select the SDK option when installing a server

  • C:\Program
    Files\QlikView\QlikView SDK

Help file can be found here

  • C:\Program
    Files\QlikView\Management Service\QMSAPIDocumentation.chm

QlikView SDK v.11 : http://community.qlik.com/docs/DOC-2639

QMS API documentation v.11: http://community.qlik.com/docs/DOC-2683

Using EDX v.11: http://community.qlik.com/docs/DOC-2650

Not applicable

Re: get jobs status on QlikView Publisher 11.2

Is it possible to get the same result by reading the publisher log file?

Not applicable

Re: get jobs status on QlikView Publisher 11.2

Alert mails from QMC can be used to get a mail when a task fails.

Alert mail inside a qvw can be used and be setup to send out an email when for example,  an application has been reloaded

There is also the possiblity to use SNMP and have queries to monitor tasks, somehow limited however.