Hello,
I am trying to work on the script/ODI package which shall update the scheduling details of a Load Plan without opening an ODI studio.
For instance, a Load Plan is scheduled to run @ 3:00 AM with OracleDIAgent from Mon to Fri and do not run on Sat and Sun. However, due to some reasons, we need to run it @ 1:AM during last week of the month. for. eg. last week could start from 28th and end on 3rd of next month depending upon the month.
Currently, I am doing this by manually creating a new schedule and setting the from and to date accordingly. I am required to do this during every month manually. Therefore, I was thinking if there is any mechanism in ODI through which I can update the scheduling information using a script or by referring SNP tables. I tried finding some information in SNP table, however, did not get any relevant info.
Anyone who has worked/has any idea may please help.
Regards
Andy