Managed File Transfer

Sterling Managed File Transfer

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only

  • 1.  Enabling and Disabling schedules using opscmd.sh

    Posted Fri September 25, 2020 05:43 PM

    Hi Forum,

    How can we stop multiple schedules using opsscmd.sh in sterling integrator?




    ------------------------------
    Sabarish Kavala
    ------------------------------

    #IBMSterlingB2BIntegratorandIBMSterlingFileGatewayDevelopers
    #DataExchange


  • 2.  RE: Enabling and Disabling schedules using opscmd.sh

    Posted Mon September 28, 2020 02:15 AM
    Hi Sabarish,

    Check this blog for your query.

    https://community.ibm.com/community/user/supplychain/blogs/tanvi-kakodkar1/2020/01/20/sterlingintegrator?CommunityKey=0d7202c6-f2a3-4b10-b716-5619d2082d8c&tab=recentcommunityblogsdashboard

    Thanks
    Manoj

    ------------------------------
    Manoj Bansal
    ------------------------------

    Original Message


  • 3.  RE: Enabling and Disabling schedules using opscmd.sh

    Posted Thu October 01, 2020 01:11 PM
    Thank you :)
    We have acheived it by writing script to execute SQL query to change the status of required Schedules from Active to Inactive and vice versa in SCHEDULE table.

    ------------------------------
    Sabarish Kavala
    ------------------------------

    Original Message


  • 4.  RE: Enabling and Disabling schedules using opscmd.sh

    Posted Mon September 28, 2020 03:51 AM
    Hi Sabarish,
    the opscmd.sh can be used in many ways, as suggested by Manoji with his link, but regarding schedules, it can only activate or deactivate the whole scheduler "engine", not a single, or multiple specific, schedules.
    I suggest you use the REST APIs with which you can retrieve all the schedules:
    curl -k --user "admin:password" -H "Content-Type: application/json" -H "Accept: application/json" --request GET "http://192.168.192.200:13061/B2BAPIs/svc/schedules/"
    and then with the PUT request type activate or deactivate that/those you need

    ------------------------------
    Emiliano Pacelli
    ------------------------------

    Original Message


  • 5.  RE: Enabling and Disabling schedules using opscmd.sh

    Posted Thu October 01, 2020 01:14 PM
    Thank you.. We have written a script file to execute a sal query to change the status from active to inactive and vice versa in SCHEDULE table

    ------------------------------
    Sabarish Kavala
    ------------------------------

    Original Message


  • 6.  RE: Enabling and Disabling schedules using opscmd.sh

    Posted Wed September 30, 2020 08:59 AM
    With Export-Import, you can use this XSL to disable all schedules after export and before import:

    <?xml version="1.0" encoding="UTF-8"?>
    <xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:sfg="http://www.stercomm.com/SI/SI_IE_Resources">
    <xsl:output method="xml" indent="yes" encoding="UTF-8"
    cdata-section-elements="sfg:SCHEDULE_TIMINGXML" />


    <xsl:template match="node()|@*">
    <xsl:copy>
    <xsl:apply-templates select="node()|@*" />
    </xsl:copy>
    </xsl:template>

    <xsl:template match="sfg:SCHEDULE_STATUS">
    <xsl:copy>
    <xsl:text>INACTIVE</xsl:text>
    </xsl:copy>
    </xsl:template>


    </xsl:stylesheet>

    ------------------------------
    Daniel Hammling
    ------------------------------

    Original Message


Related Content