Executing a function in another database doesn't work

[BorislavZlatanov]

I've created two separate databases for timetable and for my app. This is for enhanced security. This issue seems very similar: #164

Here is the command I use for creating the job:
SELECT timetable.add_job('myjob','* * * * *','SELECT public.fetch_data()','["--dbname=my_app_db"]'::jsonb);

pg_timetable says: function public.fetch_data() does not exist (SQLSTATE 42883)] [txid:1067] Task execution failed

But I can verify the function exists in the my_app_db database, in the public schema, and I can successfully execute it from terminal.

This is on Ubuntu 20.04, Postgres 14, pg_timetable 5.6.

[pashagolub]

This issue seems very similar: #164

No, it's absolutely not. That issue is for an ancient version of schema. There is no even such a table anymore.

'["--dbname=my_app_db"]'::jsonb

This is not gonna work. These suppose to be parameters/arguments for tasks, just like function parameters/arguments.

Check the sample on how to establish remote task. There is no way to create a remote job with timetable.add_job() function