asked
Sql jobs failing once and complete on retry
Weird stuff, having random failures the past 3 nights in a row during nightly processing. 1.Child packages are run by the parent 5 times before failing the job that runs the parent, when this happens, the child is manually reset and ran again and then it completes on the first try sometimes, and sometimes not for the 4th or 5th try, sometimes requiring running it manually in BIDS, where it completes successfully. 2.Due to this delaying downstream processing some jobs are manually turned off but then they are still running somehow 3.tables being empty even though the package didnt fail Any help is greatly appreciated!
Are there errors of any kind? Output in the logs? Anything? There's not enough information here for me to even make a guess.
15 People are following this question.
