We are using cognos 10.1 version.
Is there a way to send email when the reports are currently executing for more that 35 mins in event studio or report studio.
I have some report running more that 35 mins. So i want to send a email to the user that following reports are been still beeing running.
what i have tried is that in the event studio, from the Audit package in the run reports query i have added the (execution time *0.001) > 2700 in the event and in the task specifed the email and added the table to display values.
but in the status field it not showing execution/ running.
how can i achieve this?
Thanks for all you help!!
Pinned topic Notify Reports That Are Currently Executing
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-29T14:39:58Z at 2013-01-29T14:39:58Z by SystemAdmin
neni 270002EYYP42 Posts
Re: Notify Reports That Are Currently Executing2013-01-28T16:47:22ZThis is the accepted answer. This is the accepted answer.In COGNOS Audit the status filed gives only two values('SUCCESS','FAILURE') and it doesn't contain anything like in progress.
You need to check in the DB frequently for active sessions & Duration of the session from COGNOS.
One way to do it create report based “gv$session”(Oracle DB) table to check for active session by filtering for COGNOS user ID used in the data source connections in COGNOS . You can schedule the report to run frequently and create an event based on whatever the condition you like to notify the appropriate users.
let me know if oyu have any questions
neni 270002EYYP42 Posts
Re: Notify Reports That Are Currently Executing2013-01-29T14:15:33ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
follow the below link for details.
once you do this check the generated SQL and you will be able to capture the user ID, report name, Report location, Package name etc.
Step 2) you need to ask your DBA to provide necessary permission for you to be able to query the necessary table related to the session information in database.
Option 1)to create the report you can create a model & package and publish to congos connection. then you can use this package to create the report or else you can add these tables to the audit package.
Option 2) you can use the SQL directly inside CONGOS report instead of importing those tables and applying necessary logic inside query subject to determine the session status & duration etc.. and creating a package
Whcih database are you using.