Update with result from CTE

Try your UPDATE with the following syntax;

UPDATE job
SET jobdate = cte.date
FROM cte
WHERE job.jobid = cte.jobid