Regarding table to monitor BODS job status

[former_member465305]

Hi All,

Is there any system table to monitor the BODS job status, which can provide us the job status, start time ,end time and job execution duration.

In case If it is not available how can we design table and reusable component in BODS to save these details at the end of every job and then we can use this details for quick reference.

Thanks in advance

[akhileshkiran]

Hi Parag Jhade,

You can use metadata tables of the local repository database to retrieve job information.

Tables: 
AL_MACHINE_INFO
AL_VERSION
AL_USERS
AL_ASUSERS
AL_REPOTYPE_NAMES

More Information about metadata tables you can go through the SAP Data Services Technical Manual and this link SAP Data Services Metadata Tables

Regards,

Akhilesh Kiran.

[former_member465305]

Hello Akhilesh,

Thanks for your response.

Is there way to redirect the output of mentioned metadata tables to HANA DB(i.e making a connection between metadata tables and HANA DB)
so that we can use this details for quick reference .

[akhileshkiran]

Hi Parag Jhade,

You can simply create a bods job 😛 on metadata db and schedule it everyday to populate the data into the HANA DB tables.

Regards,
Akhilesh Kiran.