Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 A question about DTS Jobs

Author  Topic 

mateamargo
Starting Member

10 Posts

Posted - 2005-06-10 : 10:20:48
I have 4 DTS Package that are called from another and finally process a cube.
Some tasks throws an error on some rows, but the trasnformation complete successfully.
My question is, this errors, can interrumpt the job?
I have scheduled the package that contains the other (every day at 12 AM). I can see it into "Management/SQL Server Agent/Jobs", but every day I check the status said "Unknown".
How can I solve this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-06-10 : 14:59:05
If it says Unknown, it means it has never been run. Either the job is disabled, no job steps have been added, it has no schedule, or the schedule is disabled.

Tara
Go to Top of Page
   

- Advertisement -