RE: [sap-basis] Unable to delete DBA schedule job in DB13
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Lars-Erik Hallsten (CEO & Senior Consultant) on Apr 27 at 11:47 AM |  Mark as helpful |
Hi Snowy
Wow! Did I really write SDBAC? Thanks for correcting that quite dangerous
typo.
I meant to write SDBAD, SDBAH and SDBAP. And as you say, table SDBAR should
also be truncated.
Thanks.
Regards,
LEH
From: Snowy via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 27. april 2010 16:44
To: Lars-Erik Hallsten
Subject: RE:[sap-basis] Unable to delete DBA schedule job in DB13
Posted by Snowy (Certified Netweaver
'04/Oracle Basis consultant)
on Apr 27 at 10:45 AM
<http://it.toolbox.com/api/ContentVote/3466569/1/1/> Mark this reply as
helpfulMark 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
__.____._ Wow! Did I really write SDBAC? Thanks for correcting that quite dangerous
typo.
I meant to write SDBAD, SDBAH and SDBAP. And as you say, table SDBAR should
also be truncated.
Thanks.
Regards,
LEH
From: Snowy via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 27. april 2010 16:44
To: Lars-Erik Hallsten
Subject: RE:[sap-basis] Unable to delete DBA schedule job in DB13
Posted by Snowy (Certified Netweaver
'04/Oracle Basis consultant)
on Apr 27 at 10:45 AM
<http://it.toolbox.com/api/ContentVote/3466569/1/1/> Mark this reply as
helpfulMark 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
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
Lars-Erik HallstenSAP Basis Enthusiast
Contributed 1,000 posts in a group to earn a Gold Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
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
_.____.__ 
