drubydoo

JTX 9.3.1 Job Query SQL Error - Insufficient Permissions

Discussion created by drubydoo on Aug 24, 2010
Latest reply on Aug 24, 2010 by tbello-esristaff
Hello all,

I am getting an 'Insufficient Permissions' error with a job query in which I would like the jobs on hold not to show up in the jobs in progress list.  The query works fine in Oracle, and is successfully verified in JTX Configuration, but then I get an error when trying to save the query.  The error seems to be generated from the last condition in the query:

JTX_JOBS.JOB_ID NOT IN
(SELECT JOB_ID FROM JTX_JOB_HOLDS WHERE
(JTX_JOB_HOLDS.RELEASED_DATE IS NULL))

The full query is attached.  Any ideas?

Thanks,
Andrew McColgan
Computer Software Specialist
Memphis Light, Gas, and Water

Attachments

Outcomes