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.

[former_member311580]

Hello Virgilio,

As Eric stated, the issue shoul be solved by re-scheduling the DB13 actions. Please, see notes 564576 and 583759.

Best regards,

Rafael

[Former Member]

Hello,

I may have the same scenario because I have two same jobs that are getting canceled in DB13. I checked them and it is because that the jobs were created in a client which is no longer existing. "Logon of user XXXX in client XXX failed when starting a step"

DBA:ANALYZETAB

DBA:CHECKOPT

Can you please tell the importance of these jobs as these are not included in SAP Note 16083 - "Standard jobs, reorganization jobs" as one of the standard jobs. If required, I need to reschedule these jobs in DB13 which I do not know how. DB13 does not have options that will create these type of jobs. So far, this is what I can only see from my DB13.

Whole database offline + r

Whole database offline bac

Whole database online + re

Whole database online back

Redo log backup

Partial database offline b

Partial database online ba

Check and update optimizer - this is for DBA:UDATESTATS

Adapt next extents - this is for DBA:NEXTEXTENT

Check database - this is for DBA:CHECKDB

Verify database - this is for DBA:VERIFYDB

Cleanup logs - this is for DBA:CLEANUPLOGS

So where does these two jobs should be generated from? I would appreciate any help regarding this.

Thanks,

Tony

[former_member311580]

Hello Tony,

You can de-schedule such jobs.

Please have a look at the note 564576 to clear the jobs in DB13.

These actions ANALYZETAB and CHECKOPT were the old version for the scheduled job in DB13 (for Oracle9 and SAPDBA)

current version there would use new function with BRCONNECT and other parameters then please check the table SDBAC (control table for DB13) and correct the entries for this problem.

Please, please also refer to note 403704

Regards,

Rafael

[Former Member]

Hi Rafael,

Thank you for the SAP Notes. This explains why. I have deleted the jobs from SM37 and no harm done. Cheers!!

Regards,

Tony

[ashish_vikas]

Hello Virgilio Padios,

Please check DB14 detail logs..did brtools started and what is the error message you are getting there ?

thanks

ashish

[former_member289039]

Hi virgilio,

Please check this note 583759

regards,

prakash