cleanuserjobs

Use the cleanuserjobs command to clean up dynamic domain manager database tables in case of jobs in never-ending EXEC status in the USERJBOBS job stream.

Syntax

cleanuserjobs -dbUsr username -dbPwd password 
-jobnum jobnumber | -file filename

Description

This command clears database tables on the dynamic domain manager by removing jobs stuck in a perpetual EXEC status within the USERJOBS job stream. You can provide the numbers of jobs to be deleted by using the jobnumber parameter, or provide a file containing a list of job identifiers by using the file parameter.

Options

-dbUsr user_name
The user name required to access the HCL Workload Automation database server.
-dbPwd password
The user password required to access the HCL Workload Automation database server.
-jobnumber
A specific job to delete. Supports the following formats:
  • #Jjobnumber
  • Jjobnumber
  • jobnumber
-filename filename
A file containing one job identifier per line. Supports the following formats:
  • #Jjobnumber
  • Jjobnumber
  • jobnumber
Run the following command to remove job 45678 from the database:
./cleanuserjobs.sh -dbUsr twsadmin -dbPwd secret123 -jobnum J45678
Run the following command to remove the jobs listed in file joblist.txt from the database:
./cleanuserjobs.sh -dbUsr twsadmin -dbPwd secret123 -filename joblist.txt
The file contains the following entries:
#J938667870
J938667871
938667872