SQL-Automation Query

 For SQL Query Automation : 

Select - Journey Builder > Automation Studio > New Automation

 Select : Starting Source Schedule and drag it to Starting source and drag SQL Query .

click on choose and select : Create new Query Activity - Name the Query

Write the Query on editor and validate the Query syntax and also create the New target data extension before moving ahead with all fields.

Now select the target data extension with action data as overwrite :

Then finish and save and name the Automation:

Now Save and Run Once the automation : Click "Select All activity" and Click on Run

Click on RUN ONCE

Query Automation Run successfully.

checked the Targeted DE found all the records are successfully updated.