pg_cron icon indicating copy to clipboard operation
pg_cron copied to clipboard

Setting Values to Condicion Query

Open MarceloBaeza opened this issue 1 year ago • 0 comments

Hello I have trying to set values to condition in query of cron.schedule:

 SELECT sc.minute_execution_cron, 
            sc.hour_execution_cron,
            sc.day_month_execution_cron,
            sc.month_execution_cron,
            sc.day_week_execution_cron,
            sc.interval_config_mount_delete,
            sc.interval_config_type_delete  into 
            x_minute_cron_cl, x_hour_cron_cl, x_day_month_cron_cl,
            x_month_cron_cl, x_day_week_cron_cl, x_interval_mount_cron_cl,
            x_interval_type_cron_cl
      FROM public."setting-cron" as sc
      WHERE sc.country = 'XX';

      x_time_cron_cl = x_minute_cron_cl || ' ' || x_hour_cron_cl || ' ' ||x_day_month_cron_cl || ' ' || x_month_cron_cl || ' ' || x_day_week_cron_cl;
      x_invertal_cron_cl = x_interval_mount_cron_cl || ' ' || x_interval_type_cron_cl;
      raise notice 'Value: %', x_invertal_cron_cl;
      --perform public."deleteLogs"('2022-08-30 12:45:00', x_invertal_cron_cl, 'CL');
      PERFORM  cron.schedule('delete-logs-cl',x_time_cron_cl, $$select * from public."deleteLogs"('2022-08-30 12:45:00', x_invertal_cron_cl, 'XX')$$);

and the error is: 2022-09-23 03:51:00.013 UTC [1057] ERROR: column "x_invertal_cron_cl" does not exist at character 58 2022-09-23 03:51:00.013 UTC [1057] STATEMENT: select * from public."deleteLogs"('2022-08-30 12:45:00', x_invertal_cron_cl, 'XX')

so, is it possible?

MarceloBaeza avatar Sep 23 '22 04:09 MarceloBaeza