Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS package executing for Long time in SQL server 2005 Expand / Collapse
Author
Message
Posted Tuesday, October 09, 2012 5:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 8:44 PM
Points: 4, Visits: 18
Hi All,

i'm working in SQL server Management Studio 2005 as a application support member, which holds
around 100 jobs scheduled to be run on daily basis. i could able to see few jobs are taking more time to
execute. for ex, if A is a job executing for 5 mins on daily basis which holds around 10-15 steps in it.
Suddenly the execution time differs from 5 mins to 5 hours which is not expected.


Added to this scenario, not only a single job is getting executed for more time.. jobs keep differs day by day. but, as per my analysis all the jobs which are taking more time to execute holds DTS package in it. SQL jobs are getting hanged in this case.

can anyone please help me to sort this out please

Thanks
Taro
Post #1370336
Posted Thursday, October 18, 2012 12:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:21 AM
Points: 285, Visits: 768
First off, this isn't a great place to post issues with SQL 2005 as DTS is 2000 and previous.

Try the SQL 2005 / Integration Services forum UNLESS these are actually SQL 2000 DTS jobs???

Regardless, the answer will greatly depend on what those packages are actually doing.

For example, one of my bigger packages just completed, hours after its normal time. I found that one of the prod servers it was accessing timed it out, so, failed job.

In other cases, I've found that network latency can cause serious delays.

Consider the sources the pkgs are accessing, as well as the transforms inside. If you don't know what a package is actually doing, it will be difficult to figure out what is suddenly taking so long.



taroboyy (10/9/2012)
Hi All,

i'm working in SQL server Management Studio 2005 as a application support member, which holds
around 100 jobs scheduled to be run on daily basis. i could able to see few jobs are taking more time to
execute. for ex, if A is a job executing for 5 mins on daily basis which holds around 10-15 steps in it.
Suddenly the execution time differs from 5 mins to 5 hours which is not expected.


Added to this scenario, not only a single job is getting executed for more time.. jobs keep differs day by day. but, as per my analysis all the jobs which are taking more time to execute holds DTS package in it. SQL jobs are getting hanged in this case.

can anyone please help me to sort this out please

Thanks
Taro
Post #1374530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse