Deleting completed scheduled job objects
To delete records for completed scheduled jobs objects from the database, use the Database Cleanup utility.
Procedure
-
From the WC_installdir/bin
directory, run the following script:
./dbclean.sh -object scheduled_job -type completed -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbuser user -loglevel loglevel
dbclean -object scheduled_job -type completed -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel
./dbclean.sh -object scheduled_job -type completed -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
dbclean -object scheduled_job -type completed -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the database name for example, myhost:1521:mydb.
- Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.