January 24, 2012 at 6:38 am
Hi,
I have a SQL Agent Job with 5 steps running several SSIS Packages on MSDB.
Usually it runs through all 5 steps with no problem.
Today the 3rd of 5 Steps did not finish and the Job was hanging in this state.
I checked the sysssislog where I log the onPostExecute events and saw that the PackageEnd Event was logged as always.
So it seems like the Job Agent did not notice the end of the step and does wait forever.
After I stopped the Job and restarted it beginning with step 4 it went through like it should.
I noticed this behaviour in some rare cases some time ago, but it never had a bigger impact.
But now I want to identify and solve this problem.
Does anyone have an idea what else I could check or ist there anyone that had the same problem?
January 24, 2012 at 11:59 pm
What does the 3rd step do?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 25, 2012 at 12:21 am
The 3rd step runs a ssis package, which is running 5 other ssis packages.
Those packages are aggregating data in different tables and moving data between sql machines.
One of those packages includes processing ob a ssas cube.
with ssis package logging i found the package end event for each of those packages.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply