When implementing repository jobs, SAP seems to have forgotten a functionality to change the repository type linked to a repository job. The field has been greyed out in Eclipse even when you are in edit mode.

So how to cope with this? Re-creating all the repo jobs you have set up for e.g. ABAP Load Balanced Connections for the ABAP Dedicated Server connection? A bit much effort. Also when replacing the SAP Repo type by your own you might not want to run through creation again.

So the answer lies – as often – inside the database. The repo type is mapped inside the mc_jobs table and is determined by two columns, mcRepositoryTypeQN and mcRepositoryTypeId.

Example

update mc_jobs set mcRepositoryTypeQN ='customer.idm.connector.abap:reptype.ABAPLoadBalancedConnection',
mcRepositoryTypeId = 11 where jobid = 1234

The above statement will update job number 1234 to another repo type.

How to get the proper values for mcRepositoryTypeQN and mcRepositoryTypeId?

Well the easiest is to just create a new job for the other repo type, get the job number from Eclipse and then

select mcRepositoryTypeQN,mcRepositoryTypeId = 11 from mc_jobs where jobid = 2345

Happy IDM programming.

SAP IDM: How to change the repository type of a repo job