Question
Hi all Does FMEServer has Listener to detect change on external SQL database log file? to trigger a workspace once it detects the change?
Hi all
Does FMEServer has Listener to detect change on external SQL database log file? to trigger a workspace once it detects the change?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
I don't think so, no.
A possible solution would be to attach a database trigger to the relevant table(s), sending a notification to FME Server when anything changes. There are many possibilities for the trigger mechanism: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Automations-General/Automations-Triggers.htm
There is a Directory Watcher in FMEServer. If your SQL database log file is put in a directory, and it is updated, then Directory Watcher could detect the change and do something.
