topic NPrinting 17 view upcoming task schedule in Qlik NPrinting

NPrinting 17 view upcoming task schedule

pedderta — Wed, 21 Mar 2018 14:18:22 GMT

Hello,

I can easily view completed tasks by going into Admin - Task Executions, but is there a way to see upcoming tasks that haven't yet started? It would be useful to check if anything is due to start before you rebooted the server for example.

Thanks

Re: NPrinting 17 view upcoming task schedule

Chanty4u — Wed, 21 Mar 2018 16:05:43 GMT

i think no other way:( but you need to open individual task and schedule time you can check.

may be rpc‌ have some inputs here

Re: NPrinting 17 view upcoming task schedule

Lech_Miszkiewicz — Wed, 21 Mar 2018 21:29:02 GMT

Hi, current NPrinitng console does not have this functionality.

Instead i have QlikView/Qlik Sense app which connects to my NPrinitng repository using postresODBC and lists all task (with their schedule settings).

How to connect to repository? -->NPrinting Repository Database - Name

Repository DB structure is quite simple, so building simple model showing you tasks and schedules should not be a problem

regards

Lech

Re: NPrinting 17 view upcoming task schedule

pedderta — Thu, 22 Mar 2018 14:30:05 GMT

Thanks for the answers, just a shame it can't be done within the console.

Re: NPrinting 17 view upcoming task schedule

haty — Thu, 13 Sep 2018 05:34:53 GMT

Hi lech_miszkiewicz‌, thanks for the suggestion, I have connected Qlik Sense to NP 17 Postgres DB. Looking at creating a Sense app to provide a view of when jobs are scheduled and their last run status. If you already have something similar are you able to share?

Re: NPrinting 17 view upcoming task schedule

userid128223 — Tue, 04 Aug 2020 23:56:21 GMT

Is it ok to connect to repository in live environment is there any risk.

PostgresSQL drivers are specific to db version. How do we know which driver to download. Does it work with Qlik ODBC connector package?

Can you please point us to an readymade app that connects to repository and show you different views, can you please post the app you have created.

Thanks

Re: NPrinting 17 view upcoming task schedule

Lech_Miszkiewicz — Wed, 05 Aug 2020 02:42:33 GMT

Hi @userid128223

Is it ok to connect to repository in live environment is there any risk.

answer: It is not supported/recommended by Qlik - you can do this at your own risk

PostgresSQL drivers are specific to db version. How do we know which driver to download. Does it work with Qlik ODBC connector package?

answer: I am not sure what do you mean - I use built in Qlik Sense driver, standard ODBC driver worked for me as well when I tried to use QlikView or i simply installed pgAdmin tool to query it directly

Can you please point us to an readymade app that connects to repository and show you different views, can you please post the app you have created.

answer: I suggest to spend some time searching community like here: https://community.qlik.com/t5/Qlik-NPrinting-Documents/NPrinting-Schedule-Monitor-NP17-and-Failed-Task-reporting/tac-p/1732419#M666

There is no app built to read whole repository... I can see many different use cases of how data can be loaded and used, but it all depends on the requirements and what you really want to see an from what angle. This subject is very broad and is going away from the subject of this topic.

Re: NPrinting 17 view upcoming task schedule

marcginqo — Wed, 05 Aug 2020 14:45:22 GMT

Thanks @Lech_Miszkiewicz for mentioning my solution.

@userid128223 , I just replied to a question in the page @Lech_Miszkiewicz was pointing to with the NPrinting Schedule Monitor.

It is quite easy to create this as long as you have a connection to the Postgres database. Be aware that not all the data can be retrieved (yet) from the database so you do need the REST API's especially when you want to have an overview of upcoming tasks.

Marc

Re: NPrinting 17 view upcoming task schedule

Troy1 — Fri, 28 Aug 2020 02:48:11 GMT

Hi Lech

Can you please share QlikView app that you have. I am able to create connection to database. Thanks

Re: NPrinting 17 view upcoming task schedule

Lech_Miszkiewicz — Fri, 28 Aug 2020 04:04:44 GMT

Hi @Troy1

I dont have QlikView app. I played with Qlik Sense one: https://community.qlik.com/t5/Qlik-NPrinting-Documents/NPrinting-Schedule-Monitor-NP17-and-Failed-Task-reporting/tac-p/1732419#M666

You can always rewrite it to QlikView one - script will be practically the same!