Job canceled

[anderson_cardozo]

Good morning, SAP Gurus.

When I schedule some jobs, this are canceled because the system ID is invalid, and is right because the system is JEQ but in the job show me SYSID = JEP. Database is oracle.

My question is how I can change the system ID and execute ok.

The jobs with problems are:

DBA:ARCHIVELOGS_____@120000/3007

DBA:CHECKDB_________@050000/4007

DBA:CHECKDB_________@050000/4007

DBA:UPDATESTATS_____@040000/3007

Enclose picture.

Thanks for your answers.

[former_member224542 · Accepted solution]

Hi Anderson,

Looking at the log, your system looks like it is running on DB2. Can you confirm?

[anderson_cardozo · Accepted solution]

Hello Glen,

The system ID is JEQ, I checked DB2.

[Former Member]

Hi Andersaon,

Below tables:

SDBAP = SAP DBA Plan Table

SDBAR = SDBA Resource Table

SDBAH = Header table for DBA protocols

SDBAD = Detail table for DBA protocols

belong to sapdba. They contain the log information of the logs that

sapdba and BrBackup and BrArchive write. The sapdba -cleanup function

will enable you to delete the entries from the db-tables, as well as the

respective files in the operating system.

The tables

MONI  = Monitor table

PAHI  = History of OS system, DB and SAP parameters

ALAMO = Collector of alert events

OSMON = Operating system monitor data

DBSNP = Table for DB snapshots

Tables:

ALSYSTEMS:CCMS Central System Management: Remote Managed Systems

As they contain information related to that source system and will be misleading if copied to target system.

Regards

Rableen

[Former Member]

Hello Anderson,

If you didn't perform certain table exports prior to your refresh then it will be reading the planning calendar of JEP.

Run tx DB13 and on the upper left of the screen you will see "DBA Planning Calendar". Just below that you will see "System" and there you will probably still see JEP.

To change it: DB13 => Goto => Backend Configuration.

Also follow up on what Subhash has suggested.

KR,

Amerjit

[former_member185031]

Hello Anderson,

Can you confirm if there was a system refresh done recently from JEP to JEQ recently and after that you are getting this issue ?

If yes then some Post installation steps activity seems missing as it is reading the old system data.

Regards,

Subhash

[anderson_cardozo]

Hello Subhash,

Yes the system was refresh 3 weeks ago from JEP to JEQ, but i don´t know where is reading the former system ID when schedule job.

[former_member185031]

Hello Anderson,

Kindly check these standard tables which usually needs to be clean as part of system refresh as it contains the old system information.

SDBAH

SDBAD

SDBAP

SDBAR

Regards,

Subhash

[isaias_freitas]

Hello,

How was the system refresh performed?

Notice you cannot simply make a backup from the JEP database and restore it at the JEQ database.

You need to use SAP tools to do this. One possibility would be a "system copy" procedure.

Regards,

Isaías