Problem with the Status of the Job

SreeMahi · Post by **SreeMahi** » 22 Jan 2009 10:30

HI,

We are ruinning SQL Server backup scripts from Control-M 6.3. These jobs are showing 'ENED OK' eventhough these jobs got failed in background.

Here is the log:

22/01/09 00:02:41 CD5065 ORDERED JOB:84528; DAILY SYSTEM, ODATE 20090122
22/01/09 00:03:08 SL5120 JOB STATE CHANGED TO Wait Time Window
22/01/09 01:00:02 SL5105 SUBMITTED TO winsql099
22/01/09 01:00:09 TR5101 STARTED AT 20090122010002 ON winsql099
22/01/09 01:00:09 TR5120 JOB STATE CHANGED TO Executing
22/01/09 02:45:09 TR5100 ENDED AT 20090122024509. OSCOMPSTAT 0. RUNCNT 1
22/01/09 02:45:10 TR5133 ENDED OK
22/01/09 02:45:10 TR5120 JOB STATE CHANGED TO Analyzed
22/01/09 02:45:10 SL5209 CONDITION BU-WINSQL099-default 0122 ADDED
22/01/09 02:45:10 SL5120 JOB STATE CHANGED TO Post processed

Can any of you please suggest me what could be the reason?

Any help will be greatly appreciated..

Thanks in Advance

Mahi

Derick · Post by **Derick** » 23 Jan 2009 8:06

Hi,

Can you post the sysout.

Zakeer · Post by **Zakeer** » 23 Jan 2009 3:06

Hi,

Verify the permission of Control-M user id, if it doesn't have required permissions it exits with ended ok.

Hope this helps.

kumarraj · Post by **kumarraj** » 31 Jan 2009 7:56

hey can some one explain clearly even I am facing same prob..\
even the sql scipt fails..still the job is endedok

philmalmaison · Post by **philmalmaison** » 02 Feb 2009 2:14

this is becaus eyour scripts giving a 0 return code
look at the way you query to ...

regards
philmalmaison