topic Re: about the job name in Application Development and Automation Discussions

about the job name

Former Member — Thu, 03 Jan 2008 06:33:23 GMT

hi all,

could anyone please tell me which table contian the Jab name ,Job status(like schelued,cancled ect.) . i want to check the job status and print all the job which cancled out.

thanks in advance

Re: about the job name

Former Member — Thu, 03 Jan 2008 06:36:01 GMT

u can check in SM37 transaction

there u r having 5 types of job status based on that u will get the lost of cancelled jobs based on user also u can select

Re: about the job name

Former Member — Thu, 03 Jan 2008 06:39:14 GMT

¡ TBTCO: The job header table (job management data)

¡ TBTCP: The job step table (individual processing steps in jobs)

¡ TBTCS: The control table for the time-driven job scheduler

¡ BTCEVTJOB: Jobs scheduled to wait for an event

Re: about the job name

arpit_shah — Thu, 03 Jan 2008 06:54:51 GMT

u can check in SM36.

click on job selection.

Regards,

Arpit

Re: about the job name

Former Member — Thu, 03 Jan 2008 07:07:36 GMT

Hi friend,

TBTCO Job Status Overview Table

TBTCP Background Job Step Overview

TBTCS Background Processing: Time Schedule Table

reward points if useful...

Re: about the job name

Former Member — Thu, 03 Jan 2008 07:10:36 GMT

thanks for your help .

but one more request.

could you also tell the the detail of the filed value (STATUS)

Scheduled:

Released:

Ready

Active:

Finished:

Terminated:

which the each value of the filed STATUS(contained in TBTCO)

regard

Re: about the job name

Former Member — Thu, 03 Jan 2008 07:34:58 GMT

Job Status Explanation

Planned:

Steps that make up the job have already been defined, but the start condition has not yet been defined.

Released

The job has been fully defined, including a start condition. Without a start condition, a job cannot be released.

Only an administrator or a user with appropriate authorizations for background processing can release a job, preventing unauthorized users from running jobs without approval.

Ready

The start condition of a released job has been met. A job scheduler has put the job in line to wait for an available background work process.

Active

The job is currently running. Active jobs can no longer be modified or deleted.

Finished

All steps that make up this job have completed successfully.

Canceled

The job has terminated abnormally. This can happen in two ways:

An administrator intentionally terminates a job with

Transaction SM37, Job ® Cancel active job

A job step contains a program that produces an error, such as:

an E or A error message in an ABAP program

a failure return code from an external SAPXPG program

Re: about the job name

arpit_shah — Thu, 03 Jan 2008 07:45:26 GMT

in TBTCO-STATUS

F - Finished

S - Schedule

A - Active

etc.

Regards,

Arpit

Re: about the job name

Former Member — Thu, 03 Jan 2008 20:42:18 GMT

hi ,

thanks for you answer .

could tell what does 'P' mean , does it mean Schelued.

and if the job cancled what does the statue return.

regards .

Re: about the job name

Former Member — Thu, 03 Jan 2008 20:58:34 GMT

Get all the jobs from TBTCO and call function module BP_JOB_STATUS_GET. STATUS = 'A' is for Cancelled jobs, F for finished and S for Scheduled, R for Active.

Here are the constants used in SM37

btc_running LIKE tbtco-status VALUE 'R',

btc_ready LIKE tbtco-status VALUE 'Y',

btc_scheduled LIKE tbtco-status VALUE 'P',

btc_released LIKE tbtco-status VALUE 'S',

btc_aborted LIKE tbtco-status VALUE 'A',

btc_finished LIKE tbtco-status VALUE 'F',

btc_put_active LIKE tbtco-status VALUE 'Z',

btc_unknown_state LIKE tbtco-status VALUE 'X'.

Edited by: Srinivas Adavi on Jan 3, 2008 3:59 PM