RE:[sap-basis] Unable to delete DBA schedule job in DB13
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Snowy (Certified Netweaver '04/Oracle Basis consultant) on Apr 27 at 10:45 AM |  Mark as helpful |
Hi, BE VERY CAREFUL! Do not delete contents of table SDBAC as suggested by Lars-Erik. This will delete all possibilities of adding new entries in DB13. you need to truncate/delete table contents. I run these SQL commands after a refresh: truncate table sapr3.sdbah; truncate table sapr3.sdbad; truncate table sapr3.sdbap; truncate table sapr3.sdbar; delete from sapr3.TBTCO where JOBNAME like 'DBA%'; delete from sapr3.TBTCP where JOBNAME like 'DBA%'; delete from sapr3.TBTCS where JOBNAME like 'DBA%'; commit; This will resolve DB13 woes and SM37 orphan jobs. Good luck!
---------------Original Message--------------- From: Peter2009 Sent: Tuesday, April 27, 2010 5:43 AM Subject: Unable to delete DBA schedule job in DB13 > Hi there, Recently I just performed a client copy from PRD to QAS. After that I tried to re-schedule all my jobs (UpdateStats then CheckDB) in DB13, but failed to delete them. When i checked in SM37, there is no more DBA* jobs. Maybe I've already deleted them. But I still can not delete these jobs. Strange! Please kindly advice on how to solve this issue. Thanks. Regards, Peter
__.____._ ---------------Original Message--------------- From: Peter2009 Sent: Tuesday, April 27, 2010 5:43 AM Subject: Unable to delete DBA schedule job in DB13 > Hi there, Recently I just performed a client copy from PRD to QAS. After that I tried to re-schedule all my jobs (UpdateStats then CheckDB) in DB13, but failed to delete them. When i checked in SM37, there is no more DBA* jobs. Maybe I've already deleted them. But I still can not delete these jobs. Strange! Please kindly advice on how to solve this issue. Thanks. Regards, Peter
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
SnowySAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
