topic Re: Table info in Application Development and Automation Discussions

Table info

Former Member — Tue, 26 Feb 2008 05:59:10 GMT

I have submitted a job. I need to find whther the job is released. can you please tell me in which table it is stored ?

Thanks

Sakthi

Former Member — Tue, 26 Feb 2008 06:01:54 GMT

Hi,

Try table TBTCO

Check the Job Status field .

Cheers

Edited by: Aditya Laud on Feb 26, 2008 1:02 AM

Former Member — Tue, 26 Feb 2008 06:05:04 GMT

Hi,

Use below logic....

Check in Table "TBTCO"

status values.

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',

From table "TBTCO" Write select statement and check the status above.

Former Member — Tue, 26 Feb 2008 06:07:37 GMT

The table is TBTCO and the status field is to be checked. The field name is STATUS for checking the job status.

Thanks and Regards

Swarna

Former Member — Tue, 26 Feb 2008 06:08:00 GMT

Hi,

please check the following tables.

these are the tables which holds data for complete back ground job scheduling.

TBTCO : Job status overview table.

TBTCP : Batch job step overview.

TFDIR : Function Module ...

BTCUED : Description of user event IDs for background processing ...

Regards,

swami.