Automic Workload Automation

Expand all | Collapse all

UC4 JOB Deactivation at Database level using query

  • 1.  UC4 JOB Deactivation at Database level using query

    Posted 23 days ago
    Team,

    Our UC4 Production copy from other UC4 Production system, currently we want to deactivate 9000+ jobs which is not required for us.
    Manually job deactivation is time consuming so we want to disable at SQL Database level, Is there any query to perform this tasks?

    Regards

    Karthik.M


  • 2.  RE: UC4 JOB Deactivation at Database level using query

    Broadcom Employee
    Posted 23 days ago
    Hi @Karthikkumar M,

    Please open a Support case and provide the Automic version and database product. Then we can send a cleanup script for your environment.

    Cheers,
    Alexander​


  • 3.  RE: UC4 JOB Deactivation at Database level using query

    Posted 23 days ago
    Hi Alexander,

    Thanks for immediate replay.
    Please find as below version of UC4 System, I am not sure how to open a support case, Kindly help me on this.

    Product: Automatic version: 2013
    Database : MS SQL 2012( 10.0.75)

    Regards

    Karthikkumar.M


  • 4.  RE: UC4 JOB Deactivation at Database level using query

    Posted 22 days ago

    I use this link to access my support cases;

    https://ca-broadcom.wolkenservicedesk.com/esd/allcases



    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------



  • 5.  RE: UC4 JOB Deactivation at Database level using query

    Posted 3 days ago
      |   view attached
    Hello Pete,

    Using the link i am trying to accessing support case i am received error as "Grant not available, Please contact admin".
    Screenshot is also attached for your reference,
    Kindly help us to access the link.

    Regards

    Karthik.M


  • 6.  RE: UC4 JOB Deactivation at Database level using query

    Posted 3 days ago
    Perhaps one of these telephone numbers would help you?

    https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=810887

    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------