Topic
  • 4 replies
  • Latest Post - ‏2013-01-29T14:39:58Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Notify Reports That Are Currently Executing

‏2013-01-26T23:48:15Z |
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!!
Updated on 2013-01-29T14:39:58Z at 2013-01-29T14:39:58Z by SystemAdmin
  • neni
    neni
    42 Posts

    Re: Notify Reports That Are Currently Executing

    ‏2013-01-28T16:47:22Z  
    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
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Notify Reports That Are Currently Executing

    ‏2013-01-28T20:57:08Z  
    • neni
    • ‏2013-01-28T16:47:22Z
    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
    Hi neni,

    Can you please let me know the steps how to do it.

    Thank you for your help.
  • neni
    neni
    42 Posts

    Re: Notify Reports That Are Currently Executing

    ‏2013-01-29T14:15:33Z  
    Hi neni,

    Can you please let me know the steps how to do it.

    Thank you for your help.
    Step 1) you need to modify the CQEconfig.xml to enable the comments for native & COGNOS SQL.
    follow the below link for details.
    http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id7554Add_Comments_Native_CognosSQL.html

    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.
    Step3)
    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.

    Thanks
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Notify Reports That Are Currently Executing

    ‏2013-01-29T14:39:58Z  
    • neni
    • ‏2013-01-29T14:15:33Z
    Step 1) you need to modify the CQEconfig.xml to enable the comments for native & COGNOS SQL.
    follow the below link for details.
    http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id7554Add_Comments_Native_CognosSQL.html

    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.
    Step3)
    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.

    Thanks
    Hi neni,

    Thanks for the reply.

    I will try this today. We are using SQL Server.

    Thanks,
    Sandy.