- Open TDP and connect to TIC
- Right click the TIC connection and choose the “New SQL Editor”.
- Run below 2 scripts to get the “running” process, the result set would be blank if there is no “running” process
Script to get running automation scripts:
select object_type, owner, script_id, script_name, status from _toad_automation.toad_auto_get_all_scripts where status = 'RUNNING';
Script to get refreshing snapshots:
select database_name, snapshot_name, status from hub_information_schema.hub_get_snapshots where status = 'RUNNING';