Skip to Content
0

Regarding table to monitor BODS job status

Aug 14, 2017 at 05:45 AM

113

avatar image
Former Member

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

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

1 Answer

Akhilesh Kiran Aug 14, 2017 at 01:46 PM
1

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.

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

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 .

0

Hi Parag Jhade,

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

Regards,
Akhilesh Kiran.

1