Scheduling based on Database value

[edsxpedx]

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

[sachin1]

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.

[ray.wurlod]

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?

[edsxpedx]

Running jobs on specific days only. Weekly - Monday, Monthly - 6th day of every month

[edsxpedx]

Please let us know how are you sheduling job, sequencer or through basic code in Job Control.
function.

Scheduling by using Sequence jobs only

[ray.wurlod]

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.