on 11-11-2008 7:34 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
db13 --> select job --> delete --> click on (recurring action/entry) --> delete. this will delete you recurring jobs.
cheers,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.