DTS scheduled job failed after 1st run (SQL 20000 SP4)

#1

I created a DTS package scheduled job through DTS Import/Export Wizard in SQL
Server 2000 SP4. scheduled to run every 10 min (copy tables from DB1 to DB2
on the same SQL server). It ran Ok 1st time, but failed on the 2nd and the
rest of them. I log on as sa to create the job. (see below)

The job succeeded. The Job was invoked by Schedule 3 (PackTwo). The last
step to run was step 1 (PackTwo).

The job failed. The Job was invoked by Schedule 3 (PackTwo). The last step
to run was step 1 (PackTwo).

Any input will be greatly appreciated.

#2

Problem solved.

"Frankie" wrote:

Quote:

I created a DTS package scheduled job through DTS Import/Export Wizard in SQL
Server 2000 SP4. scheduled to run every 10 min (copy tables from DB1 to DB2
on the same SQL server). It ran Ok 1st time, but failed on the 2nd and the
rest of them. I log on as sa to create the job. (see below)

The job succeeded. The Job was invoked by Schedule 3 (PackTwo). The last
step to run was step 1 (PackTwo).

The job failed. The Job was invoked by Schedule 3 (PackTwo). The last step
to run was step 1 (PackTwo).

Any input will be greatly appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS scheduled job failed after 1st run (SQL 20000 SP4)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS scheduled job failed after 1st run (SQL 20000 SP4) - 06-22-2006 , 02:48 PM

RE: DTS scheduled job failed after 1st run (SQL 20000 SP4) - 06-22-2006 , 03:59 PM