If you are using MS SQL, open SQL Server Management Studio, login to the MDB server,
open a new query window and run the following:
use MDB
GO
declare @var_objectid varchar(50)
declare job_delete cursor for
select objectid
from usd_job_cont with (nolock)
where state=8 and objectid in (select jobcont from usd_jcview with (nolock))
and
objectid in (select jcchild from usd_link_jc with (nolock))
and
objectid in (select jcont from usd_link_jc_act with (nolock))
open job_delete
fetch job_delete into @var_objectid
While (@@fetch_status=0)
begin
Delete usd_jcview where jobcont=@var_objectid
Delete usd_link_jc where jcchild=@var_objectid
Delete usd_link_jc_act where jcont=@var_objectid
Delete usd_cc where objectid=@var_objectid
Delete usd_job_cont where objectid=@var_objectid
fetch job_delete into @var_objectid
end
close job_delete
deallocate job_delete
GO
When that is done, the job will be gone from DSM Explorer. Just refresh the view.
Thanks,
Joe Puccio
Senior Engineer, Software Support