Skip to Content
0

Is there a BODS job monitor system table?

Feb 18 at 09:57 AM

109

avatar image
Former Member

I use the SAP BODS v14.2. I run every night batch job in Production environment using SAP BODS. Sometime these jobs get stalled and I am not aware it. I would like to get informed if the BODS job gets stalled and does not progress at all. Are there any tables that can be checked for a BODS system status regarding such jobs? If yes, I would be able to schedule a job that can check this status and update me with the progress of the job. I already have a table that records the start time and end time of data-flows called BODI BATCH STATUS but that does not serve the purpose. Could someone help me out? Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mohammed Ashraf
Feb 19 at 10:56 AM
0
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 26 at 12:01 PM
0

Hi,

AL_HISTORY metadata table holds the status of your job on whether its still running/Completed/Failed.

Kindly check.

Thanks,

Sandhya

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for the answer. This table does give the status but does not let us know the job is really running or it is stalled without updating the STATUS on this table.

My Nightly Batch job looks like it is running but sometimes it does not do anything. In such cases referring to this table does not prove to be useful. I can check the log files but they are stored in the server. Is there a way to automate the process of notifying that the job is actually not progressing but still appears running?

0

Create a control table and you can the status there if the job is still running or executed. You can even create one more job with a script to check the status of this job in control table and and include a smtp_to function to get alerts of the status.

0
Rajan Burad Feb 28 at 10:36 AM
0

Hello,

Modify your existing BODI BATCH STATUS table and add a column with "Status" to it.

1.) Write a script at the start of job that sets the status value to "Running"

2.) Write a script at the end of job that sets the status value to "Completed"

You can now query the table and fetch the status after specific time intervals so as to know whether your job is completed or not. But as you said that you want to know that your job is progressing or not then it can be done using tables in your job which have date column mapped to them. If your respective tables, having date columns, returns sysdate then it means those dataflows have been completed.

Hope it helps!

Share
10 |10000 characters needed characters left characters exceeded