sap - Data Services ETL Script Job name ID not being pulled -

i have job keeps failing saying job not defined in control job table. job name in control table different etl name i've updated in our control table reflect correct etl job name still failing. print statement showing job name same job name in control table, no spaces or in it.

in our job control script within etl job, value of job_name() assigned variable $g_jobname.

it set this:

$g_jobname = job_name() ;

i assuming procedure/function pulling etl job name , comparing job control table. both job names match in script not getting job id using job name scalar value? print out job id empty.

the script thus:

$g_job_id = sql('data_source_job_control','select jobid job_ctrl_tbl  ltrim(rtrim(upper(job_name))) = ltrim(rtrim(upper({$g_jobname})))  ') ;     print('diprint: $g_job_id: ' || $g_job_id) ; 

the id used further processing or fail out depending on if null or not.

thanks

andrew