dbTalk Databases Forums  

Packaged Deleted But Still Running/Scheduled

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


Discuss Packaged Deleted But Still Running/Scheduled in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
will
 
Posts: n/a

Default Packaged Deleted But Still Running/Scheduled - 10-10-2005 , 07:35 PM






I created a few packages for DTS to export on a daily basis. For some reason,
they have an error. So I deleted them. But they seem to be still scheduled
and running because the error messages keep coming up in my Application log.

This is the error I am getting:
SQL Server Scheduled Job 'dbo_sodetail' (0xF66A1C6EE1B5594DA80051F518C957F7)
- Status: Failed - Invoked on: 2005-10-10 00:00:20 - Message: The job failed.
The Job was invoked by Schedule 7 (dbo_sodetail). The last step to run was
step 1 (dbo_sodetail).

Right now, I just want to make sure everything has stopped before trying to
debug that problem. What do I need to do to get these ghosts deleted? Thanks!


Reply With Quote
  #2  
Old   
Resant
 
Posts: n/a

Default Re: Packaged Deleted But Still Running/Scheduled - 10-11-2005 , 12:02 AM






Have you delete the job under SQL Jobs Management?


Reply With Quote
  #3  
Old   
will
 
Posts: n/a

Default Re: Packaged Deleted But Still Running/Scheduled - 10-13-2005 , 11:17 PM



Yep, there were entries in there and I deleted them.

Management -> SQL Server Agent -> Jobs

We will see tomorrow.

Thanks!



"Resant" wrote:

Quote:
Have you delete the job under SQL Jobs Management?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.