The Delete Jobs by Job State enables you to delete all jobs by one or more job states.  The command is executed from the main menu using Database | Jobs by Job State.  To execute this command the user’s group must have access to “Clear Selected Tables” in the User Groups settings.  This command can be used to delete jobs by job state from DMS so that new jobs can be imported via a SQL script or a text file.  Note that once a job is deleted, it cannot be recovered.

The example below shows the Delete Jobs by Job State screen:

To execute the command:

1. Select File | Delete Jobs by Job State or click on the delete icon.

2. Delete assembly structure as required  If this option is selected and a job to be delete is part of an assembly structure, the entire assembly structure is deleted.  Note that other jobs that are not to be deleted and are part of the assembly structure are NOT deleted; just the assembly structure (relationship between jobs) is deleted.  If this option is not selected and a job to be deleted is part of an assembly structure with children, the job is not deleted.

3. Select Job States for the Jobs to Delete  Select the jobs states of the jobs you want to delete.  One or more jobs states must be selected from the drop down menu; a blank selection of job states is not allowed.  When the pull down menu is selected, each job state appears.  Click the check box on the jobs states you want to delete.  As each job state is selected, it is listed in the prompt separated by a semi colon as in the example below:

4. Click OK to delete the jobs by with the selected job states.  Click the Cancel button to cancel.

The Delete Jobs by Job State can also be executed in a batch or command file.  See Auto Delete Jobs by Job State for more information.