Hi. If I schedule a job with input parameters, is there anyway to set those input parameters so the job can be automated. For instance, if a job is run everyday and you want the job to process rows with today's date. Would there be a way to set that?
Thanks for your help!
Nicole
Input parameters
Moderators: chulett, rschirm, roy
Sure, wrap it with a sequence job with a single activity stage calling your current job and in the job activity properties, set the current date using OCONV() in the parameter derivation for your input parameter. Thats one way to do it.
Another way is to code the current date inside the job rather than as a job parameter so that it picks up the current date whenever it runs.
Another way is to code the current date inside the job rather than as a job parameter so that it picks up the current date whenever it runs.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.