SQL 2000 Disable Job question

[Catadmin]

Here's a weird one.

Can a job (Job B) be created to disable another job's schedule (Job A) but not Job A itself?

I would think so since there is an Enabled column in sysjobschedules, but since I don't want to directly modify a system table, I'm looking for another way to do it.

My only other option is to have Job B disable itself, but that won't work either. @=) As far as I know, a job can't disable itself.

Any thoughts?





Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

Nevermind. I found it. Sorry about the foolish question.

sp_update_jobschedule was what I was looking for.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"