![]() But I realized now that it is affected by the running time of each iteration. The Execute Command I currently set the 'Sleep 1800' command for the job to sleep 30 minutes to end the iteration of the loop. The first iteration the UserVariables pass variable A (SQL statement 1) to the Job Activity, from the second iteration, it will pass variable B (SQL statement 2) to the Job Activity. The UserVariables Activity is to pass variables (SQL statement) to filter data getting in the Job Activity. The first loop iteration will load data from 8 PM the previous day to 8 AM the current day, and the others will load data that happens in the last 30 minutes. ![]() The job will run every 30 minutes (8 AM - 8 PM) to get real data. Here is the flow: StartLoop Activity -> UserVariables Activity -> Job Activity -> Execute Command -> Endloop Activity Currently, I have a sequence job in DataStage.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |