Weird that SQL JOb failed while the package execute could be successful.

daiju

Weird that SQL JOb failed while the package execute could be successful.

by daiju » Sun, 27 Jan 2008 13:47:01

More than 10 times, i validated the package can be executed successfully, if i use a SQL job to run this package. All data and function goes well, however the job result reported failure after i saw the job 100% completed.

That 's so weird.

Anyone met the same the issue.

Could anyone give me some suggestion or hints

Debugged it frustrateed~~




jwelc

Weird that SQL JOb failed while the package execute could be successful.

by jwelc » Tue, 29 Jan 2008 14:48:02

If you turn on logging in the package, you might get a better idea what is going on. A couple of things to look at: If you have any code in the PostExecute event handler for the package, it can appear that the package executes successfully, but the event handler fails, which causes a failure report. I also saw this scenario on an RTM version of 2005 - patching it to SP1 resolved the issue.