How do you schedule a DI job with BOE scheduler?

[system]

I searched for topics on scheduling DI jobs with BOE.

I didn’t see a “how to” from the posts. We have a DI job that needs to run after a file is created and placed in a folder.

I went to the admin to schedule the job. However, the BOE scheduler option is grayed out.

Is this really an option? Is the only option to use the wait_for_file function in a script? If that is the only way, does anyone know of a sample of how to use this in a script?

Thanks.

---

webtechie (BOB member since 2007-10-10)

[system]

https://wiki.sdn.sap.com/wiki/display/BOBJ/Scheduling

You have to register the CMS in WebAdmin → Management first.

---

Werner Daehn (BOB member since 2004-12-17)

[system]

I have a newly installed instance of BOE XI R3 on one machine and my Data Integrator 11.7.2 instance on another machine. I can’t seem to get the DI Management Console to connect to the CMS. This is the error I get:
Login to CMS failed:Unable to find servers in CMS MTGI21 and cluster with kind cms and extra criteria null. All such servers could be down or disabled by the administrator.

I’m brand new to BOE so I don’t know if there is additional configuration necessary to get DI to talk to it. I can get into the BOE CMC screen OK.

---

eganjp (BOB member since 2007-09-12)

[system]

I am making progress on this. The “BOE scheduler” option is available within the DI screen for scheduling a job. However, when I try to activate the schedule on the BOE scheduler I get the following error:

Server Input% not found or server may be down

The connection to the CMS seems to be OK. I don’t get any complaints when I hit the Test or Apply buttons.

This is using DS 12.0.0.0 and BOE 12.1. All installed on the same machine.

---

eganjp (BOB member since 2007-09-12)

[system]

to workaround the % input error
you will need to change the name of the BOE Input server to the following format

Input.<…> prefix the serve name as Input.
stop the server first and then rename it

---

manoj_d (BOB member since 2009-01-02)

[system]

I have finally got the BOE scheduler to work in DI.

You have to create the CMS connection first.

Then you create a schedule in DI for the job to run. If you need the job to run multiple times/days, just set the schedule to run one day. You just need the reference to the job in BOE.

Then when I went into BOE, I saw the data integrator folders and the reference to the job.

From there, I was able to schedule the job with events.

I have created a pretty complex little system for our reports that need to have certain DI jobs run first.

It seems to work well. I have files that trigger DI jobs which create trigger files which run reports. I can have some DI jobs that have to wait on more than one dependent situation before they can run.

---

webtechie (BOB member since 2007-10-10)

[system]

The link posted by Werner doesnt work anymore. Anyone has the latest link?

Thanks

---

zigzag (BOB member since 2009-09-13)

[system]

updated the link to the correct one I hope.

---

Werner Daehn (BOB member since 2004-12-17)

[system]

Did you have to change the name of the input server? I can see the empty data services folder in CMC but there is nothing in it no matter how hard I try!

---

zigzag (BOB member since 2009-09-13)

[system]

???

---

Werner Daehn (BOB member since 2004-12-17)

[system]

@manoj_d

you can use BOE file event mechanism to send the data file
for scheduling DS job in BOE, the error you are getting is know issue and the work around is to rename the BOE Input and Output FRS Services, with the following convention

Input..FileRepository
output..fileRepository

BOE allows you to rename the services

I think you have posted this in multiple places, try this and see if it works

regarding using try catch and using mail_to and smtp_to function you can define the SMTP server in the server manager, but these functions don’t give a option to attach files, these functions are useful in error handling, like a job failed and you want to send alerts with trace and error file

---

zigzag (BOB member since 2009-09-13)

[system]

I have been trying to schedule DI (12.X) jobs with BOE (XI 3.1) scheduler.

I have reached a stage where I can see the Data Services folder in BOE. I can also see my ‘Test_DI_with_BOE’ program. However when I right click and schedule the program, it fails. Please see the attached screenshot. Can anyone guide me here?

Thanks

---

zigzag (BOB member since 2009-09-13)

[system]

open the properties of the ‘Test_DI_with_BOE’ program object and expand the schedule node, under this you will see a option named Program Logon, click on that and sepcify the windows credential to execute this program

you can also set default User from Settings, Check BOE Adiministrator documentation about scheduling Program obejct or check with your BOE Administrator

---

manoj_d (BOB member since 2009-01-02)

[system]

Hi Manoj

Thanks for your reply. I specified that and now I am getting a different error. Please see the snapshot.

Thanks

---

zigzag (BOB member since 2009-09-13)

[system]

click on the last run date and time link for the Instance that failed, it will open the output file of the process in notepad, do you see any errors in that

what is DS Version?

---

manoj_d (BOB member since 2009-01-02)

[system]

How do you do that? When I click on the time instance, all that opens is the screenshot that I have attached with my previous email.
Sorry I am a bit of a novice…

---

zigzag (BOB member since 2009-09-13)

[system]

you will see this page when you click on the Status of the Instance, click on the Instance time

check the attachment
program_log.zip (19.0 KB)

---

manoj_d (BOB member since 2009-01-02)

[system]

Thanks I managed to make it work, but I now have another issue.

The program job / object executes successfully within BOE and shows ‘Success’

However, nothing happens…and nothing is executed

Example:
I have tried to schedule a simple DI extract job within BOE. Though it shows ‘success’, the DI job is not executed and no extracts take place

Thanks

---

zigzag (BOB member since 2009-09-13)

[system]

the success status of program object doesn’t mean that the application that is executed by the program object is successful (in this case Job). The success status mean the BOE Program JobServer was able to launch the program successfully

you didn’t mention the DS version, if you are on DS XI 3.1, please check the following post you might be running into same issue

120×120 10.4 KB

No trouble connecting and setting up schedule in BOE from DI. When scheduled to run, history in BOE indicates success, but job never runs in DI. Using Instance Manager in BOE, I find the attached text file. Not being a Java guru, I don’t know what it means. program[1].txt (0.0 KB) jmcilvaine (BOB member since 2007-06-14)

post the output file of the program object, it will have the details of why the Job failed

---

manoj_d (BOB member since 2009-01-02)

[system]

Thanks for your help so far Manoj.

I have made some progress:

The job runs successfully within BOE and I am also able to receive custom email notifications.

However, I get the email notifications only when the job passes.

If they fail, I do not get any notifications inspite of configuring the email to send out notification…

To test the ‘fail’ notification, I introduced some errors in my job, saved it and closed DI. I then ran the job through BOE.
The BOE scheduler ran for 2 seconds (the job should take 5 mins) and gave a ‘Success’ message with a ‘success’ email notification.

Any advice here?

Thanks

---

zigzag (BOB member since 2009-09-13)