Is there a way to customize the return_message
of cron.job_run_details
?
I need a more descriptive return_message
than just SELECT 1
.
In my case, the cron job uses dblink
to make a call to functions in other databases:
example:
SELECT * FROM dblink('other_db'::TEXT, $$
SELECT * FROM some_function(now() - INTERVAL '14 days', now())
$$) t (message text);