how to view ALL batch job details (SM37) at one glance ?

[Former Member]

Dear all,

I am documenting all released batch job details, the information required includes the job name, client number, job frequency .. etc.

In order to see that information, i go to SM37 and click on each job to see the details. I have about 60 jobs released, to get their details i have to click on them at least 60 times.

Is there a report or table that i can refer to that provides me the information of all the jobs in one screen ?

Thanks.

Advice and comment will be appreciated.

Regards,

Kent

[Former Member · Accepted solution]

Kent,

Check this link, it may be helpful to u.

Regards,

Prashanth

Edited by: Prashanth L on Jul 20, 2009 7:22 AM

Edited by: Prashanth L on Jul 20, 2009 7:23 AM

[Former Member · Accepted solution]

Dear Prashanth,

Thanks for the link, I managed to get the required information from table TBTCO or TBTCP with below selected fields.

JOBNAME = Background job name

SDLSTRTDT = Planned Start Date for Background Job

SDLSTRTTM = Planned start time for background Job

SDLUNAME = Initiator of job/step scheduling

PRDMINS = Duration period (in minutes) for a batch job

PRDHOURS = Duration period (in hours) for a batch job

PRDDAYS = Duration (in days) of DBA action

PRDWEEKS = Duration period (in weeks) for a batch job

PRDMONTHS = Duration period (in months) for a batch job

PERIODIC = Periodic jobs indicator ('X')

STATUS = State of Background Job, S = Released, F = Finished

AUTHCKMAN = Background client for authorization check

EVENTID = Background Processing Event

EVENTPARM = Background Event Parameters (Such as, Jobname/Jobcount)

Dear Juan,

Thanks for your reply.

Regards,

Kent

[JPReyes]

You should be able to pull most of the information from table TBTCP, make sure you select all the required columns to be displayed via SE16

Regards

Juan