How to find long running scheduled Spotfire reports from action log?

[Prabakaran Rangasamy]

I would like to build a query to get long-running reports. For example, I need to find the reports that are running for more than 20 minutes. How can I get these details from the action log?

[Olivier Keugue Tadaa]

Hi Prabakaran,

Could you try this ?

select * from actionlog

where log_category='scheduled_updates' and log_action= 'job_execution'

and arg2='IN_PROGRESS'

To set the "20 minutes" condition, you can play with the original_time and the "datatimeNow()"

You can then combine the result with the JOB_INSTANCE (from Spotfire database) to get the report name (link lib_item_id with libraryId (or id2)

https://docs.tibco.com/pub/spotfire_server/12.3.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/action_log_entries.html

Hope this helps

Olivier

[Olivier Keugue Tadaa]

SELECT *

FROM ACTIONLOG

WHERE LOG_CATEGORY = 'scheduled_updates'

AND LOG_ACTION = 'job_execution'

AND ARG3 = 'IN_PROGRESS'

[Fredrik Rosell]

Adding to what Olivier wrote, are you looking for historic data - schedules that took more than 20 minutes to complete sometime in the past - or are you trying to look at scheduled jobs that are currently running?

[Prabakaran Rangasamy]

Thanks Olivier. Let me try this..

[Prabakaran Rangasamy]

Hi Fredrik, I am looking for scheduled jobs that are currently running.

[Prabakaran Rangasamy]

Is there any way to get the report name from Action log itself. It looks like the action log table has report path.