Batch Job monitoring

[Former Member]

Hi,

We have 40 - 50 Batch jobs running in our ECC systems which we need to monitor on daily basis.

Is there any way to store all the jobs in SAP and it automatically generates a report suggesting the failed jobs.

This will enable us to take action on the failed jobs rather than analyzing each and every job which is again time cosuming.

Please suggest.

Regards,

Shubhram

[narukurti]

You can do it from SAP system itself. Query the table TBTCO for the status of the job scheduled. If the status is 'A' then the job was cancelled by the system due to error.You can create a small program with a query like 'SELECT STATUS FROM TBTCO WHERE JOBNAME='ZZZZ' AND STRTDATE=sysdate'  and schedule it . You can configure email and SMS based on the result of the query. In our organization we have created two programs.

1. To query the table TBTCO and insert a record in ZTABLE based on the status of the job.

2. To query the ZTABLE and send SMS and email to the defined numbers.

[Former Member]

Hello,

It depends on exactly what you want but you could check out note

Note 553953 - RZ20: Monitoring background jobs

Link: [Note 553953|https://websmp230.sap-ag.de/sap/bc/bsp/spn/sapnotes/index2.htm?numm=553953]

or [help|http://help.sap.com/saphelp_nw70/helpdata/en/1c/48803d48de0610e10000000a114084/content.htm]

Enter your jobs into table ALBTCMON as per the note. (pattern matching of the job names is possible).

Once the batch monitor is active you could then setup auto reaction methods or check the history of each job in RZ20.

Regards

Robert

[Former Member]

Hi, it's depend's how many Application server's you configure for background processing ...

For example in central system --> Rz20 --> SAP CCMS Monitor Templates --> Background Processing

--> Background Processing Servers --> servername --> Background --> AbortedJobs

You can also create the sms or mail sending automaticaly if job's are failing and comes in this CCMS "abortedjobs"

Regards.

[Former Member]

As advised in the above respons, monitoring 40 - 50 jobs is simple using transaction sm37.

If you just want to see the failed jobs you may choose only the cancel status and view what all jobs fail.

However in our scenario where we have 1000's of jobs running everyday we use a separate tool to monitor ALL jobs on various servers. This tool is configured in sync with another patrolling tool known as BMC patrol which generates an alarm for every failed job. Having such tools configured in the environment is a great advantage!!

[Former Member]

Hi Subhram,

First of all 40 to 50 Jobs is not too much to see in SM37 to verify which one has failed. Also extracting a list of cancelled jobs can solve your problem.

However if you are looking a report solution, there is no standard SAP way. You can design a query on table TBTCO to get your desire report.

Regards,

Sanujit