What Orace Tables are behind DB13/DBACOCKIT Calender

[Former Member]

I would like to run a SQL statement to check if certain DBA jobs (Update Stat and DBcheck) are schdeuled.

What oracle tables do I need to look at?

Thanks in advance.

[Former Member · Accepted solution]

Hi Bill,

You can check TBTCO table to check certain jobs, on DB13. You can query this table for all scheduled job definitions, also, such as JOBNAME="*CHECKDB*"

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

...and the detailed logs of update stats (*.sta) and checkdb (*.chk) are located in the filesystem under /oracle/SID/sapcheck.

Cheers Michael

[Former Member · Accepted solution]

If I run this query I get the results for the last week...

SELECT JOBNAME, STATUS, LASTSTRTDT
  FROM SAPSR3.TBTCO

WHERE (JOBNAME LIKE '%DBA:UPDATESTATS%' OR JOBNAME LIKE '%DBA:CLEANUP%' OR JOBNAME LIKE '%DBA:CHECK%')

   AND  LASTSTRTDT  >= TO_CHAR(SYSDATE-7,'YYYYMMDD')

   AND  LASTSTRTDT  <= TO_CHAR(SYSDATE,  'YYYYMMDD')

ORDER BY  JOBNAME;

What column do I use to tell if the job ran successfully?

[Former Member · Accepted solution]

Hi Bill,

STATUS='F' means that the job ran successfully.

Best regards,

Orkun Gedik

[volker_borowski2]

Hi,

several tables starting with SDBA* are related to DB13.

Check the systemcopy guides. Esp. the ones that are to be deleted after a system copy might be relevant. SDBAH, SDBAP, ... ?

Volker

[Former Member]

Where do I get the 'systemcopy guides'?????

[volker_borowski2]

http://service.sap.com/instguides

Select your product on the left like

NW -> NW 7.0 -> Installation

Volker