cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete periodic DB13 jobs

Former Member
0 Kudos

Dear All:

Our system environment is ECC 5.0 on SQL SERVER 2005, we had defined a periodic backup jobs with DB13, now we wanna delete those jobs , i found i can only delete it one by one, how can i delete those periodic jobs in one time,please give some advice, thanks a lot

Regards

Alex Cheng

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

you can truncate this table:

SDBAP

then, go into SM37 select:

job name DBA*

username *

dates 01011900 31129999

click on Execute

press F5

press Shift - F2

Answers (1)

Answers (1)

Former Member
0 Kudos

db13 --> select job --> delete --> click on (recurring action/entry) --> delete. this will delete you recurring jobs.

cheers,

-Sunil