Jobs need to be run(monthly/Weekly) based on the value of database.
I want to automate this piece. EX: There is a vendor table.. In RUNONLY column we have two values Monthly and Weekly. Based on that we have to schedule our jobs at VENDOR level.
Your suggestions are appreciate.
Thanks
Venu
Scheduling based on Database value
Moderators: chulett, rschirm, roy
Re: Scheduling based on Database value
Please let us know how are you sheduling job, sequencer or through basic code in Job Control.
In first case we can check values using routine activity stage.
in second cases we can find out value in database and call DSRunJob function.
In first case we can check values using routine activity stage.
in second cases we can find out value in database and call DSRunJob function.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please be more precise about weekly and monthly. Is this on a specific day (e.g. weekday for weekly, month date for monthly)? Do you want to run something every day that determines whether the job runs or not?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Scheduling based on Database value
Scheduling by using Sequence jobs onlysachin1 wrote:Please let us know how are you sheduling job, sequencer or through basic code in Job Control.
function.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The job sequence needs to run daily. If it's Monday (Iconv(Date(),"DWA") = "Monday") it runs the weekly job. If it's the 6th (@DAY = 6) it runs the monthly job. You can add additional activities to retrieve the database value, of course.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.