Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 05 at 12:17 PM

    You can hack the AL_SCHED_INFO table in the repository, to deactivate:

    • update AL_SCHED_INFO set ACTIVE= 0 where SCHED_NAME = '<the name of your schedule>'

    Set to 1 to activate again.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 05 at 08:22 AM

    Go to SAP Data Services Management Console, Administrator > Batch > {YOUR_REPO_NAME} > Batch job configuration tab > press Export execution command for scheduled job, *.bat file will be created here C:\ProgramData\SAP BusinessObjects\Data Services\conf\

    Add comment
    10|10000 characters needed characters exceeded