Hi,
I got a requirement to activate/deactivate the BODS schedules through BAT/DOS script. Is there any way for this? Can anyone please help?
Thanks
Dave
Davidkrn (BOB member since 2013-10-03)
hi,
short answer is no, long answer is maybe, kind of.
The cmc schedule is only loosely coupled with the actual execution of the job.
The way it works is that the cmc creates a scheduled task (or cron job in unix) on the job server and also writes a record into al_sched_info in the repo DB.
manipulating that DB record directly will have no impact on the scheduled task, so the only way would be to directly alter that task at os level in a DS script somehow. That’s probably not that difficult but it is a little messy.
However, that’s all relatively complex, i’d have thought it would be easier to maintain some kind of schedule table, so each job can start, check that table to find out if it is meant to be running, then just stop without doing anything if not? Unless there’s some reason why the job can’t even begin and end straight away?
wil992 (BOB member since 2011-06-22)