 Hey guys welcome to SSUnitex which is in this side and today we are going to see about the schedule trigger. In the last video we have seen about the triggers and today we will be going to start with the one of the type of the trigger that is scheduled. So what is schedule trigger? So schedule trigger run the pipeline on the wall clock schedule. So what it means? So for example we want to execute any pipeline on any specific period of time like we want to execute the pipeline on every day at six o'clock. So we can schedule that and that pipeline will be going to execute at six o'clock. Next when we are going to create the schedule trigger you specify a schedule like we have to specify the start date like from which date the schedule will be going to start. So what is the recurrence? So recurrence is basically on what period we want to execute the pipeline again. So that is the recurrence and after that and that like on what date we want to stop this trigger so that we can specify right there. So for the trigger and associated with the pipeline. So while we are going to create the trigger after creating the trigger we also need to associate that trigger with the pipeline. So that we will see in this video after that you can create the schedule trigger to schedule a pipeline to the periodically like we can schedule the trigger on the R basis on the daily basis on the monthly basis and other options as well. So that we will see. So go to on the browser and we will see in the practical. So here if you have remembered like we have created this pipeline and this pipeline is going to copy the data from as yours equal from one table to another table. Now for creating the trigger either we can click on this add trigger and click on this new or edit or we can go in the manage tab and under the manage tab we have these triggers under this author. So we can go under this trigger and click on this create trigger option. Now here we can provide some name for the trigger. So this is for the schedule trigger. So we can have this like scheduled trigger. We can also specify the description of that trigger. Then here we can see the type. So as we have already seen in the last video we have four types of trigger schedule trigger tumbling window trigger storage event and custom event. So we are going to create the trigger in this video with the schedule trigger. So we can select the first option. Now here we can see the start date. So this start date is indicating from what date we want to start the execution of this trigger. So here as we can see to 28 2022. So this time we can see it is 239 p.m. So we can set that like today we want to start the execution of this and the time. So here this clock is 24 hours. So 2 p.m. So it means 14 and after that 39. So we want to start the execution at 45 and the second that we can set as 00. So it will be going to start execution from today and 245 p.m. And we can click on OK. So this will be your start date. And after that we have to select the time zone. Like I am in the India time zone you might have in the another time zone. So accordingly we can select this time zone. So I am going to select for India time zone that is UTC plus 530. And after that here we can see the request. So on every 15 minutes we want to execute or we are also having the other options like we have the R basis. So on every 15 hours or only one hour we can execute this so that we can select. And while we are going to set the days and week. So let me go in the days. So here we can see these days. So go to on the week. In case of week here we can select the days on what days we want to execute this. Like we want to execute Monday Tuesday Wednesday Thursday Friday. We don't want to execute the trigger on Saturday and Sunday. So we can select those. Let me unselect all these. And the last option that is the month. So in the month days we can see here we can select the days by which we want to execute the trigger. The second option that we can see the weekday. So on the weekday here we can add the new request so that I am not going to add. I am going to select the first option on every 15 minutes we want to execute this trigger. Now here we can see the option to specify an ended. So if you want to specify any ended so from that date this trigger will be going to expire. So I am going to expire this trigger by tomorrow and we can specify any time and click on OK. So this trigger will be going to expire by tomorrow. And after that we can see here we have a start trigger. So let me click on this start trigger on creation. So while we are going to create this trigger it will be started. Let me click on OK. So your trigger will be ready. It will take little bit time. So here we can see this trigger is created. And here we can see the option like in the related we have zero. This is because this trigger is not associated with any pipeline. So go to on the author tab and inside the author tab under this copy details we can go under this add trigger and click on new or edit. So in the choose trigger we can see the option for the new or the trigger which we have created right now. So let me select this one. Let me click on OK. Let me save this. So this is done. Now we have to publish this change. So we can click on the publish. So after that we have to click on OK here. So the change only the trigger that we have added. So it should be deployed soon. So here we can see published completed. So we can see it's 243. So let me pause this video and we'll back in two minutes. So now we can go in the monitor tab and we'll see the execution. So here under the pipeline runs we can see the first option and it got executed at 245. And this is executed just now the trigger that we have created. And here it is succeed that we can see. Or we can go in the trigger runs and under the trigger runs here we can see. So here the execution by using the triggers. So those are available here. Now go to on the minus tab again and under that trigger here under the related we can see one. So we have related this trigger with one of the pipeline and we can check the pipeline name here. Let me click on this. So this is the pipeline name by which we have related this trigger. So thank you so much for watching this video. If you really like this video please subscribe our channel to get many more videos. See you in the next video.