Background Job Tables

[Former Member]

Hi,

we have some programs scheduled for background jobs for daily basis.I don't know all the program names and the scheduled user-id's.

I want to know the table name where it stores the Program names and UserId's...because by giving user-id I want to know all the scheduled job programs with that Id.

Is there any table available?

thanks in advance,

fractal

[Former Member]

Hi,

Check TBTCO table

thanks,

PRamod

[suresh_datti]

try the following tables..

TBTCJSTEP                      Background Job Step Overview  
TBTCO                          Job Status Overview Table     
TBTCP                          Background Job Step Overview  

~Suresh

[Former Member]

Hi Suresh,

Are these the only tables?

I heard there are many more.

Can you please clarify?

Regards,

Bharadhwaj.R

[Laxmana_Appana_]

Hi,

Check this database view : <b>V_OP</b> ,

in this view you will have all required fields.

Regards

Appana

[Former Member]

Use the table TBTCP.

Regards,

Prakash.

[Former Member]

We can also use BTCJSTAT to look at the jobs that ran few months before and also when jobs in sm37 removed. This table will contain logs that are even deleted.