Automatic run a windows script when a file is added to a windows folder - TechRepublic
Question
July 29, 2014 at 10:07 AM
gunnar.melby

Automatic run a windows script when a file is added to a windows folder

by gunnar.melby . Updated 11 years, 10 months ago

Hi all Windows scripting experts

I have a question how to set up automatic start of a .batscript on Windows 2008.

Example description:
We recieve a file from the CRM-system with general ledger (GL) transactions every evening that is later loaded into the ERP system (IFS Applications). Usually is this process followed.

1. An Oracle package/procedure (in the CRM-system) stores GL files in folder “CRM_GL_FILES” on a file server every evening at 1830.
2. A Windows .bat script to rename the files to a fix naming standard runs every evening at 1900 using Windows scheduled tasks.
3. A scheduled job in IFS Applications loads the GL files in folder “CRM_GL_FILES” starting 1915.

Usually this process works fine, but some times is the Oracle package/procedure in the CRM-system delayed and GL-files are stored in folder “CRM_GL_FILES” later than 1900. Further automation of this process is required.

Is it any function in Windows 2008 to automatic run the rename bat-script when GL-files are loaded to folder “CRM_GL_FILES”?
Is it possible in Windows scheduled tasks to run two or more scripts a task Chain so that the load procedure of GL-files to IFS ERP-system starts when the renaming is completed.

All suggestions and tips are welcome.

Thanks in advance.

Best regards

Gunnar B Melby
System Manager
Energiselskapet Buskerud, Norway

This discussion is locked

All Comments