are there any error messages associated with the DTS Job Is it possible that
the table that are being dropped have locks on them at the time of the job
run? Just something to think about


>From: "Justin Gilli" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] DTS job fails occasionally
>Date: Wed, 29 Oct 2003 12:02:05 -0500
>
>I have a DTS scheduled job that fails every so often. Maybe once a week,
>but I never go a week without a failure.
>The job drops and recreates 3 tables copying data from the main db.
>I notice that if I separate the job into 3, 1 table per job, I never have a
>problem.
>Anyone experience this problem?
>
>Thanks in advance,
>
>Justin Gilli
>
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] to check if your PC is virus-infected? Get a FREE computer virus scan
online from McAfee.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

MS Sql Server LazyDBA home page