USERJOBS clean up utility

New tool to clean up dynamic domain manager database tables

The USERJOBS tool has been developed to clean up dynamic domain manager database tables in case of jobs in never-ending EXEC status in the USERJBOBS job stream. To resolve USERJOBS carryforward issues, the new cleanuserjobs.sh(bat) command is now available in the TWDWB/bin directory to automate the procedure. The command syntax is as follows:
On Windows operating systems
cleanuserjobs.bat -dbUsr username -dbPwd password 
-jobnum jobnumber | -file filename
On UNIX operating systems
cleanuserjobs.sh -dbUsr username -dbPwd password 
-jobnum jobnumber | -file filename
where:
  • jobnumber supports the following formats: #Jjobnumber, Jjobnumber or jobnumber.
  • filename contains a list of jobs, with one job per row.