October 20, 2008 at 6:08 am
Hi everyone!!
I´ve scheduled a DTS Package using SQL Server Agent.
This package basically truncates a few tables (about 15), imports data from an Oracle server into these tables and then runs some queries.
The job started on friday and kept running the whole weekend. Now, I take a look a the tables and see only four tables were updated.
The amount of records is very acceptable. Of those 15, only three have a maximum of 28000 records. The other ones have an average of 50 records.
The transformation tasks are designed to work in parallel.
Additionally, if I run the DTS Package manually it works fine.
Has anyone had a similar problem, I´m going crazy.
Thanks in advance.
Regards,
Fernando López Frezza
October 20, 2008 at 7:39 am
Are there any other processes running over the weekend on either the SQL Server or Oracle DB that could be causing blocking\deadlocking? Could there be connectivity issues?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 21, 2008 at 12:08 am
fernandolopez_fjlf (10/20/2008)
Hi everyone!!I´ve scheduled a DTS Package using SQL Server Agent.
This package basically truncates a few tables (about 15), imports data from an Oracle server into these tables and then runs some queries.
The job started on friday and kept running the whole weekend. Now, I take a look a the tables and see only four tables were updated.
The amount of records is very acceptable. Of those 15, only three have a maximum of 28000 records. The other ones have an average of 50 records.
The transformation tasks are designed to work in parallel.
Additionally, if I run the DTS Package manually it works fine.
Has anyone had a similar problem, I´m going crazy.
Thanks in advance.
Regards,
Fernando López Frezza
Use the SQL Server Agent Error Log to trap the errors if any::
http://msdn.microsoft.com/en-us/library/aa213805(SQL.80).aspx
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
October 21, 2008 at 5:26 am
Hi!! Thanks for your answers.
It seems someone made a change to one of the views in the Oracle server late on friday. Because of that, the query takes about 1 minute per row to process.
Now we are changing the view for a snapshot.
Thank you so much.
Regards,
Fernando López Frezza
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply