Find all released jobs that starts the report RDSMOPREDUCEDATA

[benoit-schmid]

Hello,

Is there a way for finding all released jobs that starts the report RDSMOPREDUCEDATA?

If there is a need to select in tbtco and tbtcs, that is fine for me.

Thanks in advance for your answer.

[Ranjith418 · Accepted solution]

Hello Benoit,

Go to sm37 , keep job name, user name as *. select released option alone and uncheck all other options. remove date in from and to date field. enter the report in field ABAP program name and execute. you can use table tbtco.

Thanks,
Ranjith

[benoit-schmid · Accepted solution]

Hello,

Could you also provide the select for tbtco?

Thanks in advance for your answer.

[Ranjith418 · Accepted solution]

Hello Benoit,

The simplest procedure is to use sm37. below is procedure for table tbtco and tbtcp.

go to table tbtcp give the program name and execute. you should get a list of jobs(status will be completed, cancelled etc). go to table tbtco and give job name and keep status field as S and then ensure field RELDATE and RELTIME are selected in selection screen. the output from TBTCO gives list of jobs released.

Thanks,
Ranjith

[Reagan]

Another one is table TBTCPV

Good Luck

RB

[benoit-schmid]

Hello,

Reagan Benjamin wrote:
Another one is table TBTCPV
Good Luck
RB

What is this third table for?

Thanks in advance for your answer.

[Reagan]

Hello

An alternative to the table TBTCP.

It will also tell you the report name used by the background job.

Cheers

RB

[Reagan]

Good Day

Query from the table TBTCP for PROGNAME and if you still want to narrow down your result then do a select between the tables TBTCO and TBTCP with the conditions.

Good Luck

RB