Error: Job Doesn't Exist - combining two tables

Hi,
I am trying to combine two different tables with different columns (that has a common id column) with the below approach:

(SELECT id as "pID", CAST(Age as int) as "pAge", CAST(NULL as double) as "value" FROM t2045328DataLake.t2045328.inventory)

UNION (SELECT id as "pID", CAST(NULL as int) as "pAge", CAST("c8y_HRM.HR.value" as double) as "value" FROM t2045328DataLake.t2045328."measurements_c8y_HRM")

but it shows this error: Job ‘…x…’ output doesn’t exist

Can someone please advise on what to do?

@shahad Are you able to share the profile of the failed job?