Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to get latest completed job count?

Former Member

‎11-03-2009 6:11 AM

0 Kudos

Hi Gurus, How can I get the job number of the latest background job of a given program? I've kept the job to run every one hour and want the job number of the last successful run so that I can get the run time and date. Basically I have a jobname and want the jobcount of the last successful run. Can you help me? Regards, Rahul

6 REPLIES 6

Former Member

‎11-03-2009 6:17 AM

0 Kudos

Do you know the table name for the job....?

Former Member

‎11-03-2009 6:17 AM

0 Kudos

Hello

Try table TBTCO with job name. You will get count.

former_member222860
Active Contributor

‎11-03-2009 6:19 AM

0 Kudos

you can check the table TBTCP

TBTCP~JOBCOUNT

GauthamV
Active Contributor

‎11-03-2009 6:21 AM

0 Kudos

Use combination of TBTCO,TBTCP tables.

kesavadas_thekkillath
Active Contributor

‎11-03-2009 6:22 AM

0 Kudos

check BAPI_XBP_JOB_COUNT

BAPI_XBP_JOB_STATUS_GET

BAPI_XBP_JOB_SPOOLLIST_READ - table TBTC_SPOOLID

Former Member
In response to kesavadas_thekkillath

‎11-03-2009 6:41 AM

0 Kudos

Solved self.. BP_FIND_JOBS_WITH_PROGRAM You get the list of run jobs and also you can also filter the list by 'only successful' runs. Then sort the list descending and get the latest alone. Thanks all.

Edited by: Rahul Raj on Nov 3, 2009 7:41 AM