How can I delete a replication job.

I cannot delete a replication job I created earlier. Delete does not show up as an action to perform. How do I delete it?

I am running Documentum 6.5 sp3 on Windows 2003 server.

I was able to delete multiple other replication jobs I created but for some reason the last three still remain.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

PanosK

Safely removing a job with DQL:


update dm_job(all) object set r_immutable_flag=0, set r_lock_date=date('nulldate'), set r_lock_machine='', set r_lock_owner='' where object_name = 'my_job_name'
go
update dm_job(all) object set is_inactive=1 where object_name = 'my_job_name'
go
delete dm_job(all) object where object_name = 'my_job_name'
go

you first have to unlock them, make them inactive and then remove all versions for good.

Panos

All comments

avksd

I assume that you are trying to delete the job that you have created(custom) and not the Documentum provided replication job.

May I know the steps you are following to delete the job ??

Instead of deleting the job - one way is just to make the job inactive.

Julien.Fontaine

Did you try delete this job directly via API or DQL ?

kguillemette

I would like to but I don’t know the selection criteria for DQL. I don’t see the object_id for this in properties.

kguillemette

The job is already inactive…I am looking to clean up a few things and I want to delete them. There is no r_object_id that I can find associated with the job so I don’t know how to code DCL to remove it.

PanosK

Safely removing a job with DQL:


update dm_job(all) object set r_immutable_flag=0, set r_lock_date=date('nulldate'), set r_lock_machine='', set r_lock_owner='' where object_name = 'my_job_name'
go
update dm_job(all) object set is_inactive=1 where object_name = 'my_job_name'
go
delete dm_job(all) object where object_name = 'my_job_name'
go

you first have to unlock them, make them inactive and then remove all versions for good.

Panos

kguillemette

First two updates appeared to work but the third delete statement is failing…

kguillemette

I finally got by the issue after I adjusted the associated ACL for the job. Thanks for your help.

Julien.Fontaine

Good news . If your problem is solved, please mark the thread as answered.