DBA: ANALYZETAB and DBA:CHECKOPT jobs failed.

[Former Member]

Hi Guys,

Good day!

I would like to seek an assistance on how can I deal with the issue below:

For JOB: DBA: ANALYZETAB

27.05.2010 04:00:20 Job started

27.05.2010 04:00:28 Step 001 started (program RSDBAJOB, variant &0000000000113, use

27.05.2010 04:00:28 Action unknown in SDBAP <<< Job failed due to this error.

27.05.2010 04:00:28 Job cancelled after system exception ERROR_MESSAGE

For JOB: DBA:CHECKOPT

Date Time Message text

26.05.2010 18:15:07 Job started

26.05.2010 18:15:08 Step 001 started (program RSDBAJOB, variant &0000000000112)

26.05.2010 18:15:09 Action ANA Unknown in database ORACLE <<<< Job failed due to this error.

26.05.2010 18:15:09 Job cancelled after system exception ERROR_MESSAGE

I also checked those DBAs and I could find any in DB13 as well as in table SDBAP.

Appreciate your help on this matter.

Cheers,

Virgilio

Edited by: Virgilio Padios on May 29, 2010 3:24 PM

[former_member204746 · Accepted solution]

Is this a refreshed system?

There is a disconnect between the job definition in SM37 and the one in DB13.

to clean hat mes up, try this:

1. in SM37, delete all job definition that starts with DBA:*

2. in DB13, delete all jobs

3. in DB13, re-create all jobs manually.

Good luck.