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
Showing results for 
Search instead for 
Did you mean: 

how to find the table having for Backgound Scheduled jobs in SM37

manoj_goyal2
Participant
0 Kudos

Can you please tell, how I can find the records for Background Scheduled jobs only defined in SM37. Please tell me the table name. What is the name of field which tell that the job is SCHEDULED.

Thanks in advance.

1 ACCEPTED SOLUTION

ferry_lianto
Active Contributor
0 Kudos

Hi,

You can check table TBTCO and field STATUS.

The values are ...

A - Cancelled

F - Completed

P - Scheduled

R - Active

S - Released

Also you can use FM BDL_READ_JOB_STATUS to find job status.

Regards,

Ferry Lianto

4 REPLIES 4

Former Member
0 Kudos

check the db table <b>TBTCP</b>

TBTCP - Background Job Step Overview

TBTCO - Job Status Overview Table

TBTCS - Background Processing: Time Schedule Table

TSP01 - Spool Req

Message was edited by:

Rajesh

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

Check table TBTCO, field STATUS

Statues are......

Scheduled: Job defined, but not yet eligible to run even if the start condition has been fulfilled.

Released: Job eligible to be started as soon as the start condition with which it was scheduled is fulfilled.

Ready: Job waiting to start. The job has been released and the job's start condition has been fulfilled.

Active: Job is currently running and can no longer be deleted or reset to scheduled.

Finished: Job has been successfully completed. All job steps completed successfully. Note: the background processing system cannot always determine whether an external job step was successfully completed. In this case, the system assumes successful completion.

Terminated: Job was ended abnormally either through user action or through an error in running a job step.

S0, in your case, you will want to check for the value 'S' in the mentioned field.

Regards.,

Rich Heilman

Message was edited by:

Rich Heilman

0 Kudos

Oh, if the value for Scheduled is "P", then I stand corrected. Sorry.

Regards,

Rich Heilman

ferry_lianto
Active Contributor
0 Kudos

Hi,

You can check table TBTCO and field STATUS.

The values are ...

A - Cancelled

F - Completed

P - Scheduled

R - Active

S - Released

Also you can use FM BDL_READ_JOB_STATUS to find job status.

Regards,

Ferry Lianto