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!

more ▼

asked Jun 06, 2014 at 03:35 AM in Default

avatar image

1 1 2

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

Jun 06, 2014 at 07:33 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 06, 2014 at 03:35 AM

Seen: 386 times

Last Updated: Jun 06, 2014 at 07:33 PM

Copyright 2018 Redgate Software. Privacy Policy