SQL to display SM37-like output

[Former Member]

Hi all,

I normally check for status of job submitted to the database.

Can anyone advise if there is any note on how to get this similar information via direct SQL statement?

I want to be able to include this into my database monitoring script especially for BI/DW databases.

Any suggestion is very much appreciated. Thanks in advance.

[stefan_koehler]

Hello,

> Any suggestion is very much appreciated

Just trace the SQL statements when calling SM37 with transaction ST05:

http://help.sap.com/saphelp_wp/helpdata/en/5a/ace273ca0211d194b500a0c94260a5/content.htm

Regards

Stefan

[markus_doehr2]

Why not use the standard CCMS for monitoring - including alerting as email?

Markus