How can I delete a replication job.
Best Answer
-
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'
goyou first have to unlock them, make them inactive and then remove all versions for good.
Panos
0
Answers
-
Did you try delete this job directly via API or DQL ?
0 -
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.
0 -
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.
0 -
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'
goyou first have to unlock them, make them inactive and then remove all versions for good.
Panos
0 -
First two updates appeared to work but the third delete statement is failing…
0 -
I finally got by the issue after I adjusted the associated ACL for the job. Thanks for your help.
0 -
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management