select
cron.schedule(
'function-schedule',
'0 0 * * *',
$$
select
net.http_post(
url:='PROJECT_SPECIFIC_URL',
headers:=jsonb_build_object('Content-Type','application/json', 'Authorization', 'Bearer ' || 'YOUR_ANON_KEY'),
body:=jsonb_build_object('time', now() ),
timeout_milliseconds:=5000
) as request_id;
$$
);
select
cron.schedule(
'function-schedule',
'0 0 * * *',
$$
select
net.http_post(
url:='PROJECT_SPECIFIC_URL',
headers:=jsonb_build_object('Content-Type','application/json', 'Authorization', 'Bearer ' || 'YOUR_ANON_KEY'),
body:=jsonb_build_object('time', now() ),
timeout_milliseconds:=5000
) as request_id;
$$
);