After days of banging my head against this, I have just fixed the SSL issue on the CKAN host which was the cause of the error Job exception: SSL_connect returned=1 errno=0 state=error: certificate verify failed.
Dozens of pages were consulted, but re-generating the SSL chain cert at this site https://certificatechain.io/ and restarting NGINX finally fixed it.