0

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);
homam
  • 1,945
  • 1
  • 19
  • 26

0 Answers0