Topic
  • 2 replies
  • Latest Post - ‏2012-10-26T05:07:02Z by SystemAdmin
SystemAdmin
SystemAdmin
203 Posts

Pinned topic Infosphere Warehouse Design Studio Schedule facility

‏2012-10-24T06:12:41Z |
My team members are using ISW Design Studio for integrating data from another data source. This operation is scheduled using Schedule facility in the Design Studio. Sometimes, the data won’t be available and the scheduled flow is failed. In such situation, we wish to run the schedule automatically after some time or before running the schedule itself, we wish to check the availability of the data in the reporting server from where we are fetching the data. Anyone could help us to solve this issue?
Updated on 2012-10-26T05:07:02Z at 2012-10-26T05:07:02Z by SystemAdmin
  • zxning
    zxning
    20 Posts

    Re: Infosphere Warehouse Design Studio Schedule facility

    ‏2012-10-24T08:20:44Z  
    Hi :

    First you must be using schedule functions in Admin Console, not Design Studio, because there is no schedule facility in it.
    About your request, there is not a simple method to check the source table. You can try the following solution:
    1. write a stored procedure in the source database, which contains a sql like "select count(*) from XXX"
    2. in the control flow, after the start operator, add a new StoredProcedure operator, and make it using the stored procedure you just created
    3. the StoredProcedure operator can output the record count value to a variable, then add a VariableComparison operator to compare the value with 0, if the value > 0 then continue executing other operators in this flow, otherwise goto the End operator of this flow directly.
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: Infosphere Warehouse Design Studio Schedule facility

    ‏2012-10-26T05:07:02Z  
    • zxning
    • ‏2012-10-24T08:20:44Z
    Hi :

    First you must be using schedule functions in Admin Console, not Design Studio, because there is no schedule facility in it.
    About your request, there is not a simple method to check the source table. You can try the following solution:
    1. write a stored procedure in the source database, which contains a sql like "select count(*) from XXX"
    2. in the control flow, after the start operator, add a new StoredProcedure operator, and make it using the stored procedure you just created
    3. the StoredProcedure operator can output the record count value to a variable, then add a VariableComparison operator to compare the value with 0, if the value > 0 then continue executing other operators in this flow, otherwise goto the End operator of this flow directly.
    Thanks for the immediate reply. We are using the Admin Console for the schedule facility. In the reporting server, always data will be available. So SQL Count function would not be feasible. But we can check the connection to the server through the SQL Query and if it fails (find from the SQL Error code), we can change the schedule time. We will try it and update.