Hi Patrick,
Audit database only gives past activities, schedules that didn't run yet will not appear here.
The query needs to be done on the Content Store database wich is not easy, therefore i suggested to use a third party content manager exploration tool.
Best regards,
Alaa
------------------------------
Alaa Eddine KAY
------------------------------
Original Message:
Sent: Mon September 12, 2022 09:10 AM
From: Patrick Neveu
Subject: How to extract details for all Cognos scheduled jobs along with the report parms?
Hi Gerald,
You might find the answer in the following document:
Logging Selected Report Parameters in the Audit DB
It is still valid with Cognos Analytics v11.x.
Best regards,
------------------------------
Patrick Neveu
Positive Thinking Company
Original Message:
Sent: Fri September 09, 2022 01:59 PM
From: Gerald Grogan
Subject: How to extract details for all Cognos scheduled jobs along with the report parms?
We are looking to extract details for all Cognos scheduled jobs along with the report parms, and the future scheduled dates/times, ect. Is there an SQL we can execute on the AUDIT schema, or perhaps a tool that will allow us to export these details into an Excel sheet? I see that I can get a list of jobs but not a way to get the underlying details (configuration) for each job.
------------------------------
Gerald Grogan
------------------------------
#CognosAnalyticswithWatson