Jump to content

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

Prabakaran Rangasamy

Recommended Posts

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)


Hope this helps


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...