Database Commands

The commands in this section are used to monitor the database.

The following commands are available:

admin
Allows you to access database sizing options.
action:<action_name>
Specify the output of the command. This argument is required. The <action_name> can be one of the following:
listall Lists a summary of the search results (not individual job/model information)
list Lists each job or model found by the search.
delete Deletes the jobs that match the search criteria.
type:<type_name> Specify the type of database entry the search will attempt to locate. This argument is required. The <type_name> can be one of the following: job, model, component, or plugin
name:<name>
Specify a job or model name.
status:<status_type>
Specify the status of a job. This command cannot be used with type:model. The <status_type> can be one of the following: cancelled, failed, or sysfailed.
username:<user_name>

Specify a user name. The search will look for this user as the model creator or job submitter.

startdate:<date>

Specify a date when a job was executed. The search will use the date you specify and all dates following it. Be sure to use the yyyy.mm.dd format. This command cannot be used with type:model.

enddate:<date>

Specify a date when a job was executed. The search will use the date you specify and all dates prior to it. Be sure to use the yyyy.mm.dd format. This command cannot be used with type:model.

creationdate:<date>

Specify the date on which a model was created. Be sure to use the yyyy.mm.dd format. This command cannot be used with type:job.