about the job name

[Former Member]

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

[Former Member]

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

[Former Member]

¡ 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

[Former Member]

hi

thanks for your help .

but one more request.

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

like

Scheduled:

Released:

Ready

Active:

Finished:

Terminated:

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

regard

[Former Member]

hi

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

[arpit_shah]

in TBTCO-STATUS

F - Finished

S - Schedule

A - Active

etc.

Regards,

Arpit

[Former Member]

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 .

[arpit_shah]

u can check in SM36.

click on job selection.

Regards,

Arpit

[Former Member]

Hi friend,

TBTCO Job Status Overview Table

TBTCP Background Job Step Overview

TBTCS Background Processing: Time Schedule Table

reward points if useful...

[Former Member]

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