create or replace task SUNO_PROD.PROD.DIM_CLIP_WEEKLY_DELETE
	warehouse=SUNO_PROD_OTHER_HOURLY_X_SMALL
	schedule='USING CRON 0 0 * * 2 UTC'
	as declare
        start_time TIMESTAMP;
        p_date date;
        p_hour string;
        stage_path string;
        row_count number;
        sql string;
    begin
        start_time := CURRENT_TIMESTAMP();
        call DIM_CLIP_DELETE_PROC() into :row_count;
        call TASK_MONITOR_INSERT_PROC('DIM_CLIP_WEEKLY_DELETE', :start_time, :row_count, 'SUCCESS', 'WEEKLY');
    end;
