Oracle scheduler: how to find jobs with wrong nls_env Posted on August 2, 2019 by Sayan Malakshinov Posted in oracle select nls_env ,count(*) cnt ,xmlcast(xmlagg(xmlelement(job_name, job_name||',')).extract('//text()') as clob) jobs from dba_scheduler_jobs group by nls_env;