Re: How to defer/stop zdlra copy-to-tape queued jobs

From: LK <lkaing_at_gmail.com>
Date: Thu, 2 Aug 2018 10:57:13 +1000
Message-ID: <CAPqBzaf=FQFsVwPL5inDgs8xMYdeeUnznp2K8L-jSY7aNr+p5w_at_mail.gmail.com>

I tried - it didnt work :(

 1 select
TASK_ID,STATE,DB_UNIQUE_NAME,LIB_NAME,FILENAME,CREATE_TIME,START_TIME from ra_sbt_task
  2* where task_id =633868104
SQL> /

   TASK_ID STATE           DB_UNIQUE_ LIB_NAME   FILENAME
CREATE_TIME                         START_TIME

---------- --------------- ---------- ---------- ----------

----------------------------------- ----------
 633868104 EXECUTABLE      LENGDB     ROBOT_TEST            02-AUG-18

09.28.07.239104 AM +10:00

SQL> exec dbms_ra.abort_sbt_task(633868104); BEGIN dbms_ra.abort_sbt_task(633868104); END;

*
ERROR at line 1:

ORA-45217: SBT task 633868104 is not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "RASYS.DBMS_RA", line 6613
ORA-06512: at line 1

Cannot find any doc on the abort_task or abort_sbt_task. Maybe it's internal and cannot be used but surely how do you stop a queued job from running??

On Thu, Aug 2, 2018 at 10:20 AM, LK <lkaing_at_gmail.com> wrote:

> Hi all,
>
> I've got jobs copy-to-tape jobs queued in zdlra. I can see approximately
> 700 jobs queued in EM due to slow tapes.
>
> I don't see anyway of aborting/deferring the queued jobs in EM.
>
> Can we use dbms_ra.abort_sbt_task? Has anybody used this? Is it safe to do
> so? I've done a google and my oracle support search and found nothing.
>
> I've got a sev 1 opened as well - no response thus far :(
>
> Thanks,
>
> Leng.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 02 2018 - 02:57:13 CEST