Script for File availability and moving the file and schedule batch job

[former_member278879]

Issue 1:

I am trying to run a batch job , When there a file exists in a folder please start the batch job and after the batch job is complete please move the file to an archive folder , I am new to Data Services and I am not sure about the scripts to put in there in the data flow. (Please see the image attached)

Script 274 I kept it for waiting for the file , script 279 is for moving the file to an archive folder , Basically I want and event trigger to do the file processing.

Issue 2:

If I get the right logic to the scripts mentioned above, How do I schedule this Data Services management console what is the process for this event based data flows.

[former_member208402]

Hello balanaveen.chilla ,

Event based triggering is not possible in BODS. if you are using any third party shceduler tool, you can implement the same file watcher and event based job triggering based upon file availability and moving the files in scheduling tool itself. No need to write scripts in BODS for watching files availabilty and moving the files.

If you would like to implement the same in BODS, Schedule the batch job at a specific time and use "if file_exists()" function to watch the file availability "sleep()" function to make job wait for the file as long as 9 hours and "file_move()" function to move the file.

In this case your job would get trigger at scheduled time and wait for the file, if file exists job will continue its extraction and then move the file.