question

rowansal avatar image
rowansal 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!
ssisprocessjob failurecompleterun
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are there errors of any kind? Output in the logs? Anything? There's not enough information here for me to even make a guess.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.