• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

MS SQL 2000 - SQL 2000 Agent

I have a SQL server agent JOB that runs on a daily basis.  I disabled the job so that i will not run, but the job keeps running despite the fact that it is disabled.

does anyone know why this would happen?
How can this be fixed?

I am running SQL 2000.

1 Solution
What type of job is it that runs and How/Where did you disable the job?
You might try restarting the agent?

Also if this is important that it does not run again, you can disable the agent in services.  

*please note that any automated backups or replication will be effected by this*
MoreThanDoubledAuthor Commented:
Its a job that processes records.
I terminal service onto the server, i open up enterprise manager, i navigate to the Management folder, jobs, double click on the job then i uncheck the enable box.

The problem is most likley because you are using teminal services to access the server. Try going to the server and sidabling the job!
You might have disabled unnecessary jobs.
But please check if other active jobs does have that specific Step in their execution?

e.g.- you disabled 3 unnecessary jobs out of 5 jobs.
So 2 are still active.
Suppose job disabled is about taking auto backup.

So please do check in steps of 2 active job that are they having same step in their execution?

2. check history of jobs in SQL SERVER AGENT. IT will give you complete desorption of which job is calling specific task n all.
 Jobs Execution statusI think this will solve your purpose.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now