Skip to Content

Is there a BODS job monitor system table?

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 19 at 10:56 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26 at 12:01 PM

    Hi,

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

    Kindly check.

    Thanks,

    Sandhya

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Feb 28 at 10:36 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded