topic Re: Background Job Tables in Application Development and Automation Discussions

Background Job Tables

Former Member — Wed, 09 Aug 2006 17:53:00 GMT

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

Re: Background Job Tables

Former Member — Wed, 09 Aug 2006 17:54:15 GMT

Hi,

Check TBTCO table

thanks,

PRamod

Re: Background Job Tables

suresh_datti — Wed, 09 Aug 2006 17:56:16 GMT

try the following tables..


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

~Suresh

Re: Background Job Tables

Laxmana_Appana_ — Wed, 09 Aug 2006 18:02:47 GMT

Hi,

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

in this view you will have all required fields.

Regards

Appana

Re: Background Job Tables

Former Member — Wed, 09 Aug 2006 18:06:26 GMT

Use the table TBTCP.

Regards,

Prakash.

Re: Background Job Tables

Former Member — Thu, 30 Jul 2009 06:03:41 GMT

Hi Suresh,

Are these the only tables?

I heard there are many more.

Can you please clarify?

Regards,

Bharadhwaj.R

Re: Background Job Tables

Former Member — Thu, 28 Jun 2012 08:13:55 GMT

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.