Starting ETL Task Execution: the SetEtl Operation

Below is the example of using the SetEtl operation to start ETL task execution. The request contains the ETL task moniker and startup parameters: execution is asynchronous. The example of checking execution status is given in the Getting Information about ETL Task Execution Status section for the GetEtl operation.

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

</tEtl>

</pattern>

<meta>

<command>RunAsync</command>

</execute>

</meta>

</tArg>

</SetEtl>

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

</id>

</SetEtlResult>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "SetEtl" : 
  {
   "tEtl" : 
    {
     "id" : "S1!M!S!L1"
    },
   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "execute" : "true"
      },
     "meta" : 
      {
       "execute" : 
        {
         "command" : "RunAsync"
        }
      }
    }
  }
}

JSON response:

{
 "SetEtlResult" : 
  {
   "id" : 
    {
     "id" : "S1!M!S!L1"
    }
  }
}

public static SetEtlResult ExecuteETLTask(EtlId moniker)
{
    var somClient = new SomPortTypeClient(); //Proxy object for operation execution
    //Operation execution parameters
    var tSet = new SetEtl()
    {
        tArg = new SetEtlArg()
        {
            pattern = new EtlMdPattern()
            {
                execute = true
            },
            meta = new EtlMd()
            {
                execute = new EtlExecute()
                {
                    command = EtlTaskExecuteCommand.RunAsync
                }
            }
        },
        tEtl = moniker
    };
    //Start tasks for execution
    var result = somClient.SetEtl(tSet);
    return result;
}