Take over jobs

[Richard_Bailey]

Hi,

We sometimes have consultants come in to do new configurations/developments and when they leave their usernames are often all over our systems, in RFC definitions, running background jobs and so on.

I've already gone through our servers and cleaned up the RFC definitions and I've cleaned up jobs by performing the tasks that usually schedule the jobs, but on the last server there are quite a few jobs to change.

Is there a way to take ownership of a job? I know I can change the user in a step but I want to also take the entire job.

Regards,

Richard Bailey

[Richard_Bailey]

While the sql is a very good solution, I was looking for something simpler. I saw on another site that I can simply log on as the permanent user and copy the job which is better for our situation.

[Former Member]

Hi

please see if this helps.

shutdown your SAP server, take a good backup and try to run these commands at database level:

update sapr3.tbtco set sdluname = '<NewUser>' where sdluname like '<OldUser>';

update sapr3.tbtcs set sdluname = '<NewUser>' where sdluname like '<OldUser>';

update sapr3.tbtcp set sdluname = '<NewUser>' where sdluname like '<OldUser>';

update sapr3.tbtco set reluname = '<NewUser>' where sdluname like '<OldUser>';

update sapr3.tbtco set lastchname = '<NewUser>' where sdluname like '<OldUser>';

update sapr3.tbtcp set prrec = '<NewUser>' where sdluname like '<OldUser>';

update sapr3.tbtcp set authcknam = '<NewUser>' where sdluname like '<OldUser>';

commit;

then restart SAP

Other than this, a customized Z-program can possibly be a solution to your problem.

REPORT ZCHANGE_JOB_OWNERSHIP .

-

---

• Program Name: ZCHANGE_JOB_OWNERSHIP *

• Title.......: Change Job/Step Ownership of Scheduled/Released Jobs. *

• Type........: Scheduled Batch *

• Description: *

• This program will change the ownership of a Job and it's *

• associated Steps. Only jobs with status Released or Scheduled *

• are selected. *

Edited by: Chetan Seth on Feb 18, 2009 7:21 AM