Deleting Scheduled Jobs

I am trying to delete 3 scheduled jobs in SQL Server 2000. I tried using the stored procedure but could not seem to get it to work and while viewing the sysjobs table in the msdn database I deleted the jobs. I also went to the sysjobschedule and sysjobsteps and deleted the coresponding jobs, however I am still getting emails everyday notifying me that the jobs have failed because SQL Server could not find job steps. Where is this coming from and how do I solve the problem.

Thank you

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!