Steps to delete validation jobs from the job monitor

1. Open Job Monitor
2. Set ‘Type’ as Validation
3. Select all records:

4. From the ‘Action’ menu select “Delete Job(s)”

Note: Some versions of Enable do not allow deleting all records, so you need to delete them one by one. If you have lots of records, you may want to delete them from SQLMS.

In this case, open the B_JOB and B_JOB_HISTORY tables and run the following queries:

SELECT *

  FROM [EPIM].[dbo].[B_JOB]

  where JOB_TYPE_CODE=3

  delete

  FROM [EPIM].[dbo].[B_JOB]

  where JOB_TYPE_CODE=3

  ---------------------------------------

  SELECT *

  FROM [EPIM].[dbo].[B_JOB_HISTORY]

  where JOB_ID in (SELECT JOB_ID

  FROM [EPIM].[dbo].[B_JOB]

  where JOB_TYPE_CODE=3)

  delete

  FROM [EPIM].[dbo].[B_JOB_HISTORY]

  where JOB_ID in (SELECT JOB_ID

  FROM [EPIM].[dbo].[B_JOB]

  where JOB_TYPE_CODE=3)