Table that stores Job Log details

[Former Member]

Dear Experts.....!!

I have an issue, for which I need to access the Start Date, Start Time and the End Time for a Particular Back-ground Job.

I'm not able to figure-out the table that contains these details.

The Input that I can provide is the Job Name and I need the recent Start Date, Start Time and the End Time for the given job.

Please help me in this regard.

Thank you all in advance.

Best regards,

Naveen

[Former Member]

HI,

the tables that stores job detials..

is TBTCO and TBTCP..

TBTCO contains the details of the job start date ,enddate status sheduled person name and full header details..

TBTCP table contains the details of all related if any person calcels the job sheduled by another person all the details regarding job stored in this table

Regards,

Prabhduas

[Former Member]

Hi Naveen,

Please check the foloowing tables --

TBTCO - Job Status Overview Table
TBTCD - Job Log Directory

For more information you can check the followings --

TBTCA                          Subsequent relationship in batch job sche
TBTCB                          Preceding relationship in batch job sched
TBTCCNTXT                      Information for Assignment of Jobs to Com
TBTCCTXTT                      Description of Reference Types for Backgr
TBTCCTXTTP                     Check Table: Valid Job Reference Types
TBTCI                          Usage counter for the job's internal repo
TBTCJSTEP                      Background Job Step Overview
TBTCO                          Job Status Overview Table
TBTCP                          Background Job Step Overview
TBTCR                          Batch scheduler execution time
TBTCS                          Background Processing: Time Schedule Table

Regards

Pinaki

[Former Member]

Hi All,

Thank you for the reply.

But I need the Start and End timings of a Job.

Here in these tables I'm not getting the fields for the timings.

Please help me in this regard.

Best Regards,

Naveen

[GauthamV]

Table : TBTCO

fileds: STRTTIME,PRDMINS,SDLTIME,LASTCHTIME.

[Former Member]

Hi Naveen,

Check the table TBTCO and the fields are -

STRTDATE  - Start date
STRTTIME  - Start Time
ENDDATE  - End date
ENDTIME  - End time

Regards

Pinaki

[Former Member]

Hi Pinaki,

I would like to know the background job duration stored table name.

Please guide me in this

Vinod.

[Former Member]

Thank you Pinaki

[Former Member]

Hi,

The table name is BTCH2170 for time.TBTCS Background processing:Time Schedule Table.

Thanks,

B.Sunil Reddy.

[service_application]

Hello,
You can use function BP_JOBLOG_READ