Topic
  • 2 replies
  • Latest Post - ‏2013-01-09T15:47:44Z by neni
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Notify a report when ran for more time

‏2013-01-09T14:59:38Z |
I need a way to be notified when a report has been running for longer than say 45 minutes – how to do this using event studio or something? We have gotten burned on more than one occasion during our data loads b/c something was stuck running.

I Appreciate all your help.

Thanks in advance.
Updated on 2013-01-09T15:47:44Z at 2013-01-09T15:47:44Z by neni
  • neni
    neni
    42 Posts

    Re: Notify a report when ran for more time

    ‏2013-01-09T15:38:22Z  
    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 at a given time and the duration of the session. You can schedule the report to run frequently and set up an alert based on whatever the condition you like in the report output version to notify the appropriate group.
  • neni
    neni
    42 Posts

    Re: Notify a report when ran for more time

    ‏2013-01-09T15:47:44Z  
    • neni
    • ‏2013-01-09T15:38:22Z
    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 at a given time and the duration of the session. You can schedule the report to run frequently and set up an alert based on whatever the condition you like in the report output version to notify the appropriate group.
    to get the Report name and user details you need to enable the comments in the generated SQL to capture report name/SQL/Model etc.. and get those details in the Database from gv$sql table.