- Open Job Monitor
- Set ‘Type’ as Validation
- Select all records:
- 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)
Comments
0 comments
Please sign in to leave a comment.