https://community.cloudera.com/t5/Support-Questions/NiFi-Scheduling-parts-of-the-processors-within-a-process/m-p/203546#M165545 <A rel="user" href="https://community.cloudera.com/users/98270/ij.html" nodeid="98270">@Ingrid Justen</A><P>1.after 1 day when the ExecuteSQL is still active and will be triggered again. I will have to test it.</P><P>Yes processor will trigger after 1 day then it will execute the sql statement again.</P><P>2.The option "<STRONG>Execution</STRONG>" (value "Primary node") does not appear in my NiFi. Is this a version thing (working with 1.6.0)?</P><P>-&gt; Stop ExecuteSQL processor</P><P>-&gt; Right click on the processor<BR />-&gt; Goto Configure<BR />-&gt; Click on Scheduling tab<BR />-&gt; Select <STRONG>PrimaryNode</STRONG> in <STRONG>Execution dropdown</STRONG>.(this property only applicable if you are having more than one node for NiFi instance).<BR /></P><PRE>1.PrimaryNode //processor is scheduled to run in only primary node<BR />2.AllNodes //if you are having 3 node nifi cluster then the processor will scheduled to run all the nodes i.e. instead of one output flowfile we are going to have 3 flowfiles with same size(this is just all nodes are doing same work results data duplication)</PRE><P><A href="https://community.hortonworks.com/questions/144016/nifi-cluster-list-files-from-one-of-the-nodes-in-t.html" target="_blank">this</A> and <A href="https://community.hortonworks.com/questions/65506/is-nifi-primary-node-and-dataflow-manager-the-same.html" target="_blank">this</A> links explains more regards to the modes of Executions in NiFi</P><P>-</P><P>For this case <B>keep the blue outlined processors</B> into <B>one processor group </B>and use <B>NiFi RestAPI</B> to start the processor group.</P><P>Once the processing is completed then By using RestAPI stop the processor group.</P><P>Following this way we are going to trigger ExecuteSQL only once, then we are stopping the group as soon as all the processing is done.</P><P>Refer to <A href="https://community.hortonworks.com/questions/185823/stop-controller-service-in-nifi-using-rest-api.html" target="_blank">this</A>, <A href="https://community.hortonworks.com/articles/110096/start-process-group-using-nifi-rest-api.html" target="_blank">this</A>,<A href="https://stackoverflow.com/questions/51706394/how-to-start-all-processors/51707791" target="_blank">this</A> links regards to stop/start processor group using <A href="https://nifi.apache.org/docs/nifi-docs/rest-api/index.html" target="_blank">NiFi RestAPI</A>.</P><P>Refer to <A href="https://stackoverflow.com/questions/51747192/stop-a-nifi-processor-group-as-soon-as-the-execution-is-completed/51747507#51747507" target="_blank">this</A> link regards to stop processor group once the execution is completed.</P> Thu, 27 Sep 2018 20:06:01 GMT Shu_ashu 2018-09-27T20:06:01Z