How to run sql query in bat file in task schedular at every 10 seconds

This is my sql script :

DECLARE @countRows     INT,
        @currDate      DATE,
        @checkForTasks INT,
        @created_by_id INT,
        @gst_ID int;
 
SET @currDate = Getdate()
SET @countRows = (SELECT Count(*)
                  FROM   [dbo].[sd_gst_effective_table]
                  WHERE  isapplied = 0)
 
IF @countRows > 0
  -- Check for those GST''s who are not applied yet : if they are greater than 0 then perform next task
  BEGIN
      SET @checkForTasks = (SELECT Count(*)
                            -- Check is current date equals to task date or not 
                            FROM   [dbo].[sd_gst_effective_table]
                            WHERE  effect_date = @currDate AND isapplied = 0)
 
      IF @checkForTasks > 0
        -- If current date = task date then perform this task 
        BEGIN
 
        SET @created_by_id = (SELECT TOP 1 createdby FROM   [dbo].[sd_gst_effective_table] WHERE  effect_date = @currDate AND isapplied = 0)
        SET @gst_ID = (SELECT gst_id FROM   [dbo].[sd_gst_effective_table] WHERE  effect_date = @currDate AND isapplied = 0)
 
            -- STEP 1 :: InActivate the existing GST according to createdbyID
            UPDATE sd_gst_rate
            SET    isactive = 0,
                   inactivedate = Getdate()
            WHERE  isactive = 1
                   AND createdby = @created_by_id
 
            -- STEP 2 :: Activate the New GST according to implementation date and gstID
            UPDATE sd_gst_rate
            SET    isactive = 1,
                   activedate = Getdate()
            WHERE  id = @gst_ID
 
            -- STEP 3 :: Inactivate the applied GST from sd_gst_effective_table
            UPDATE [dbo].[sd_gst_effective_table] SET isApplied = 1 WHERE gst_id = @gst_ID
        END
  END
 
  DECLARE @Text AS VARCHAR(100)
DECLARE @Cmd AS VARCHAR(100)
DECLARE @value nvarchar(1000);
SET @value = (SELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds);
SET @Text = 'File Writed ' +  @value
SET @Cmd ='echo ' +  @Text + ' > E:\AppTextFile.txt'
EXECUTE Master.dbo.xp_CmdShell  @Cmd

This is resided in videos folder of windows , i have created a task schedular in windows 8.1 to run daily at every 10 seconds , but it is not working ... Please tell me how to deal with it.

Please note : This sql query is running perfectly in sql server. Query have no errors. Please check whats wrong with my time schedular. I just want my schedular to run every 10 seconds regardless of date.