create or replace task SUNO_PROD.PROD.DIM_CLIP_LYRICS_DAILY_UPSERT
	warehouse=SUNO_PROD_OTHER_DAILY_X_SMALL
	schedule='USING CRON 15 7 * * * UTC'
	as declare
        start_time TIMESTAMP;
        p_date date;
        row_count number;
    begin
        start_time := CURRENT_TIMESTAMP();
        p_date := DATE(SYSDATE() - INTERVAL '1 DAY');
        call DIM_CLIP_LYRICS_UPSERT_PROC(:p_date) into :row_count;
        call TASK_MONITOR_INSERT_PROC('DIM_CLIP_LYRICS_DAILY_UPSERT', :start_time, :row_count, 'SUCCESS', 'DAILY');
    end;


