Get job id from inside running job

[mwisnicki]

I couldn't find any way to access id of currently running job from inside the function, which would be useful for logging purposes

[meenakumar36]

Hi, If you need the job id only for logging purpose, as you may know already, the job id is already logged in the application log of postgresql.

As an example:
2025-02-04 17:27:01 IST [1114030]: [32-1] db=,user= LOG: cron job 12 starting: call donightlyjobm();
2025-02-04 17:27:02 IST [1114030]: [33-1] db=,user= LOG: cron job 12 COMMAND completed: CALL

I don't find any other reason for using the job id from within the job. As far as I see, there is no direct way to get this id for now. Let me know if there is any other use of this job id from within the job. Will check on this further. Thanks.