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
 Import/Export (DTS) and Replication (2000)
 Delete a DTS Job

Author  Topic 

billsack
Starting Member

35 Posts

Posted - 2007-10-11 : 10:19:07
Hi,

I have a DTS job that I cannot delete using Enterprise Manager. It just hangs and then EM crashes.

Can anyone help please?

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-12 : 00:09:35
Tried with msdb..sp_delete_job?
Go to Top of Page

billsack
Starting Member

35 Posts

Posted - 2007-10-12 : 05:42:49
Cheers but I have deleted from the system tables on msdb

[msdb].[dbo].[sysdtspackages]
Go to Top of Page
   

- Advertisement -