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

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
    ACCEPTED ANSWER

    Re: Notify a report when ran for more time

    ‏2013-01-09T15:38:22Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: Notify a report when ran for more time

      ‏2013-01-09T15:47:44Z  in response to neni
      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.