It has been reported that Incremental Query activities have appeared hung for hours but they eventually resolve themselves on their own. While this may indicate an issue, this can also be part of the activity's normal behaviour. Incremental Query activities have been designed to operate differently than a standard query when the query attempts to return zero rows. The query never actually hangs, but instead it elects to go into a waiting status whereby it will wait until the next scheduled execution.
This can produce the following characteristics:
Query Activity never outputs any results to the transition
Audit Logs for the activity show that the query has been executed but no errors or results are returned
Perform the steps below to confirm that the Incremental Query is running correctly:
Review the Audit logs to confirm that there are no errors.
Open the Incremental Query and confirm from within the query preview that the current criteria will return results.