[thelist] SQL dts job intermittent failure

Les Lytollis leslytollis at dimensions-corporatewear.co.uk
Tue Nov 16 04:06:30 CST 2004


Hi All

Hope this is not OT.

We have a suite of SQL Server jobs that populate a web app from a legacy
data source.

Each table that is updated has an associated job containing separate DTS
packages for each step.

Step 1 is to DROP the table using IF EXISTS from the
information_schema.tables
On success the job should run 
Step 2 - create the table
Step 3 - populate, etc

The problem is that step 1 intermittently fails to run for apparently
random tables! 

Each DTS should write to the log on failure and step 2 should only run
on success of step 1 but what happens is that the table is not dropped,
nothing is written to the log and step 2 runs (and of course fails
because the table still exists)

I have no idea where to go with tracking this one down - any advice,
even on where to start would be appreciated.

Regards
Les Lytollis
Web Developer 




********************Confidentiality Notice & Disclaimer ***********************
This message, together with any attachments, is for the confidential and exclusive use of the addressee(s).
If you receive it in error, please delete the message and its attachments from your system immediately and notify us by return e-mail.
Do not disclose, copy, circulate or use any information contained in this e-mail.

(1) Whilst we have taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses, we cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment.
(2) The sender shall remain solely accountable for any statements, representations or opinions that are clearly his or her own and not made in the course of employment.
***********************************************************************************



More information about the thelist mailing list