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

job never finishes! Expand / Collapse
Author
Message
Posted Monday, October 24, 2005 8:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 21, 2007 3:48 PM
Points: 154, Visits: 1

Hi there,

Can anyone tell me that how to fix this issues! I have one job that export the data to warehouse and never finishes up at all!!

any idea?

 

Thanks




Post #231664
Posted Monday, October 24, 2005 8:49 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 12:24 PM
Points: 3,475, Visits: 579

Hi,

You have to check what is going on.

Try to execute this job by steps and see what happens.

What is the job anyway? Is it DTS package or SQL Statement? Try to execute it task by task if it is a package. Try to export just the minimal amount of sample data to see how long does it take.  Log messages at every step of the package.

Yelena

 




Regards,
Yelena Varshal

Post #231678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse