deleting jobs manually as they are locked in xmeta.

peep · Post by **peep** » Wed Oct 17, 2012 12:35 pm

While deleting jobs we have this error :The Job "XXXX"cannot be found in the repository"
so before i delete the job I would like to run "cleanup_abandoned_locks.sh "

will this cause any adverse effect if i run it once in a week just as maintance ?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 17, 2012 2:15 pm

No. If there are no abandoned locks it will do nothing.

ankursaxena.2003 · Post by **ankursaxena.2003** » Wed Oct 17, 2012 2:39 pm

I don't know if this link will help you.
But, you can give a shot at it for deleting the job from Unix.

Once, my project was corrupted and I could not see the job in Designer but it was present in Director. So at that time I found the below link to delete the job manually.

http://publib.boulder.ibm.com/infocente ... layer.html

ray.wurlod · Post by **ray.wurlod** » Wed Oct 17, 2012 4:40 pm

x is a placeholder for the table name(s) returned by the IN clause. You need to study DB2 SQL a little more, it would seem.

peep · Post by **peep** » Wed Oct 17, 2012 5:30 pm

ok sure.
thanks