DSXchange

Thank you, but how do I do a 5 minute check using the looping concept? Batch1 doesn't update the table with sysdate, its done by Mainframe developers manually. I don't have a file to use the wait for file activity

Its ESP Scheduler

Let me make this more clear. In the current scenario in scheduler, we have 2 batches dependent on each other. Batch 1 is a mainframe batch that updates source tables with updated values which exceeds more than 24 hours. Batch2 (A DataStage sequence) is dependent on batch1 execution completion since ...

Thank Craig and Franklin. Yes, we use a third party scheduler. So can I go ahead with the below approach? -->Extract date from the table. -->Start loop -->Check if the date in the table is equal to system date. -->If Yes, go ahead and write this to a file. -->Else wait for 5 minutes (How do I achiev...

Hello Everyone, I have a requirement to run and complete a Parallel job based on a value in an Oracle table. Need your valuable suggestions how can this be accomplished. Oracle table (table1) contains a Date attribute. Date in table1 is updated with System Date every day once anytime between 12 AM a...