CA Client Automation

  • 1.  Deleted staging job stay in terminating status for along time

    Posted May 26, 2017 10:49 AM

    Hello,

     

    I have send a lot of sd package to a lot of ss in a staging job 3 days ago. I deleted the job when I noticed the situation. But job is still in Terminating status. What can I do to delete this job.

     

    Best Regards,



  • 2.  Re: Deleted staging job stay in terminating status for along time

    Broadcom Employee
    Posted Jun 01, 2017 02:49 PM

    Have you tried recycling CAF and CAM on the DM and/or SS's ?

     

    That should resolve the issue.



  • 3.  Re: Deleted staging job stay in terminating status for along time
    Best Answer

    Posted Jun 02, 2017 10:18 AM

    If you are using MS SQL, open SQL Server Management Studio, login to the MDB server,

    open a new query window and run the following:

     

                use MDB

                GO

    declare @var_objectid varchar(50)

    declare job_delete cursor for

     

    select objectid

    from usd_job_cont with (nolock)

    where state=8 and objectid in (select jobcont from usd_jcview with (nolock))

        and

        objectid in (select jcchild from usd_link_jc with (nolock))

        and

        objectid in (select jcont from usd_link_jc_act with (nolock))

     

     

    open job_delete

    fetch job_delete into @var_objectid

     

    While (@@fetch_status=0)

    begin

    Delete usd_jcview where jobcont=@var_objectid

    Delete usd_link_jc where jcchild=@var_objectid

    Delete usd_link_jc_act where jcont=@var_objectid

    Delete usd_cc where objectid=@var_objectid

    Delete usd_job_cont where objectid=@var_objectid

     

    fetch job_delete into @var_objectid

    end

     

    close job_delete

    deallocate job_delete

    GO

     

     

    When that is done, the job will be gone from DSM Explorer. Just refresh the view.

     

    Thanks,

    Joe Puccio

    Senior Engineer, Software Support



  • 4.  Re: Deleted staging job stay in terminating status for along time

    Posted Jun 02, 2017 10:38 AM

    Hi Joseph,

     

    This script solved my problem.

     

    Thank You.