Find out particular printers that are being used by background jobs.

[Former Member]

Find out particular printers that are being used by background jobs..

Hi Gurus,

I have to remove some printers from SPAD, but before removing those printers I have to make sure that those are not being used by any background jobs.   The table TBTCP can be used to identify which jobs are still using those printers, but this is a tedious process. 

Any input would be highly appreciated.

Thank you

Adil

[Former Member · Accepted solution]

Hi Adil,

Have a look in table TBTCO and filter on field PDEST.

KR,

Amerjit

[Former Member · Accepted solution]

Hi Amerjit,

Thank you for your input, this is little bit of helpful.  But I have a bunch of printers, I am entering each printer in the PDEST and execute which is time consuming.  A report might be helpful that gets the desired results.

Adil

[Former Member · Accepted solution]

Hi Adil,

I'm lazy so I'd just run this SQL

select distinct(jobname), pdest from SAPSR3.TBTCP where PDEST in ('LP01', 'LOCL') ;

Just put the printers you want as shown above and just perform a little manual cross check by checking the job in SM37.

And that's it .....

Cheers,

Amerjit

[alwina_enns]

Hello Adil,

you can use the reports BTCAUX05, BTCAUX02, RSPO0040 as described in the notes:

1145265 - In which job has this spool request been created?
1226171 - Identifying jobs with deleted printer
1040456 - Where-used list for output devices

Regards, Alwina