Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am facing an issue due to day light saving.
My server is in UK and load job is scheduled at UKT, where as my file timing follows IST(India time).
After day light saving change in UK, Now my schedule is running before the file arrives in landing folder.
How to resolve such situation, manually changing schedule twice every year is not a good approach
If there's no direct trigger between placing files in a source folder and app loading it's worth to make sure files are there, besides the running hours. Minimalists example:
SET vFile='lib://Folder/Do_I_exist.txt'; DO UNTIL FileSize('$(vFile)')>0 Sleep 100000; Trace Not yet...; LOOP TRACE You can load the data now; exit script;