Good afternoon,
We have a Job that have the next File trigger:
"File Trigger. Monitoring folder 'D:\VisualCron\Jobs', file mask '*.*' for events Created,Changed,Deleted,Renamed."
This job has only a task: write to the file
"D:\VisualCron\Jobs\IT\Files 2 SQL\Files\{DATEFORMAT(yyyy.MM.dd.HH.mm)}.sql"
the next line:
INSERT INTO data (path, filename, timestamp, changetype, path_old, filename_old) VALUES ( "{STRING(Replace|{TRIGGER(Active|LastTrigger|File.Result.TriggerFolder)}|\|\\)}", "{TRIGGER(Active|LastTrigger|File.Result.Name)}", "{DATEFORMAT(yyyy-MM-dd H:mm:ss)}", "{TRIGGER(Active|LastTrigger|File.Result.ChangeType)}", "{STRING(Replace|{TRIGGER(Active|LastTrigger|File.Result.OldFullPath)}|\|\\)}", "{TRIGGER(Active|LastTrigger|File.Result.OldName)}" );
This job stop working next day while new files has created. We "solve" the problem checking "Reset trigger dependency state when saving Job", until it stops again (at next day more or less).
We have another job like this but File trigger is
"File Trigger. Monitoring folder 'D:\VisualCron\Jobs', file mask '*.zip' for events Created." and perform more complex tasks than the first and we don't have any issue with it.
Could you help us?
Thanks.
VisualCron Server 9.1.5 on Windows 2016
Edit: we have "Files 2 SQL" in "Exclude folder mask".
Edited by user
2020-06-11T13:16:24Z
|
Reason: we have "Files 2 SQL" in "Exclude folder mask".