Remove old spool files to keep track of the number of jobs in the system (SQL procedure version)

Last Updated on 11 September 2025 by Roberto De Pedrini In my last article “ Remove old spooled files to keep track of the number of jobs in the system ” I published the source of a CLLE program that removes spooled files selected by JOBNAME, USERNAME, DAYS (Retention days), FILENAME, USRDTA and OUTQ in use on the systems I administer. Two readers pointed out to me that the same purpose can be achieved using the DELETE_OLD_SPOOLED_FILES IBM procedure but only after customizing it. …