Error in DB job

All questions about Control-M jobs definitions
Post Reply
User avatar
ppraveen
Nouveau
Nouveau
Posts: 27
Joined: 01 Jul 2010 12:00

Error in DB job

Post by ppraveen » 01 Mar 2013 7:15

Hi All,

I have DB job with open query, in which at one point i have used a autoedit variable for date in the query, it is not executing properly showing error as "ORA-00936: missing expression", but if i place the date directly into query then it is getting successful.
This happens only few DB jobs,unable to diagonise the cause, please let me know what things need to check.

Thanks in advance...
Top
User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:
Contact fyot

Post by fyot » 06 Mar 2013 9:59

Hi

Check account used to launch your job and profile's variables.
Top
Post Reply

Return to “Job Definition”