Hello,
I need assistance and pointers on how to set conditions, triggers, and calendar based upon data from a nightly batch file. The results need to be stored in a variable and/or used to set a trigger(s) to run other jobs and/or used to set conditions.
I attempted using a powershell script, but am not sure how to save the output to a variable(s), trigger a job, and/or set conditions. I also tried using the readfile task to compare the output, but am not sure how to compare substrings within the file.
Any Help? I am open to all ideas and suggestions. Thanks in advance.
~~~Background information~~~
We retrieve a file via FTP/SFTP from our source system to determine if it has finished processing for the day. In this file, it also contains the following.
- Next dates jobs will run
- Previous dates will ran
- Days from and till End of Month / End of quarter
~~~Other Good information to know~~~
- Calendar exception dates have been set in the group.
- Job runs nightly. Completion time will vary each night due dependencies on other applications and processes.