Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Login
  • Contact Us
English (UK)
US English (US)
GB English (UK)

You Bring the MFT Questions

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

Popular Topics: Public,

  • Home
  • Public
  • Vendor - Specific
  • GoAnywhere

Identifying stuck monitors

Written by Richard Auger

Updated at September 29th, 2023

  • Public
    Vendor - Specific
+ More

Occasionally monitors may become 'stuck' in GoAnywhere.  You can easily create and schedule a project to identify this and receive email notifications.

The first thing to do is to create a query to check inside the GoAnywhere database.  This will require you to have a database resource defined.  Monitor information is stored here inside the dpa_monitor table, including a column that denotes the next time that monitors are expected to run.  The easiest way to generate the query is to use the SQL Wizard (System - Tools), however, the query to execute is this:

SELECT monitor_name, running, status, next_fire_time FROM GADATA.dpa_monitor WHERE running = '0' AND status = 'A' 
The column ‘running’ is set to be either 1 or 0, 1 indicating that the monitor is running at this time.  The ‘status’ column contains either ‘A’ for active monitors, or ‘I’ for inactive monitors.

The project requires a SQL step to run the query and return the results to a rowset.

Following this, loop through the rowset and compare the next_fire_time column (which is returned in Millseconds) against the results of CurrentTimeMillis() in an if statment.

If the next_fire_time value is lower than CurrentTimeMillis(), send an alert.

This project should be scheduled to run on a regular basis.

 

 

 

identify stuck monitors

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  1. Projects from 2023 User Group session "Using Common Code in workflows"

     302 views of this article

  2. How to Set Up OAUTH2 in GoAnywhere

     768 views of this article

Copyright © 2025 Pro2col Ltd

Terms of Sale

Privacy Policy

Support T's & C's


Knowledge Base Software powered by Helpjuice

Expand