BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

How to Activate/Deactivate DS Job Schedule using BAT script


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Davidkrn
Forum Member
Forum Member



Joined: 03 Oct 2013

Posts: 12



PostPosted: Sat Feb 02, 2019 8:56 pm 
Post subject: How to Activate/Deactivate DS Job Schedule using BAT script

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
Back to top
wil992
Forum Member
Forum Member



Joined: 22 Jun 2011

Posts: 26



PostPosted: Wed Jul 17, 2019 6:22 am 
Post subject: Re: How to Activate/Deactivate DS Job Schedule using BAT scr

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?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0264 seconds using 18 queries. (SQL 0.0026 Parse 0.0009 Other 0.0228)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo