|
Home > Archive > MS SQL Server > June 2005 > Disabled job continues to run
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Disabled job continues to run
|
|
| Jon Goughnour 2005-06-29, 8:23 pm |
| Thinks sounds a little crazy, and please tell me I'm wrong, but I thought
when you disable a scheduled job, it would no longer run. Do you really have
to disable the schedule inside of the job in order to keep the job from
running and not just disable the job itself?
Thanks,
Jon
| |
| Narayana Vyas Kondreddi 2005-06-29, 8:23 pm |
| Disabling the job should be fine. Can you check the history and see who is
invoking it? Could it be that there's another job that runs this job using
sp_start_job?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"Jon Goughnour" < JonGoughnour@discuss
ions.microsoft.com> wrote in message
news:DC301B21-E312-44F4-8B72- EF883EF19913@microso
ft.com...
> Thinks sounds a little crazy, and please tell me I'm wrong, but I thought
> when you disable a scheduled job, it would no longer run. Do you really
have
> to disable the schedule inside of the job in order to keep the job from
> running and not just disable the job itself?
>
> Thanks,
>
> Jon
| |
| Jon Goughnour 2005-06-29, 8:23 pm |
| Yes, I was thinking that may be the case also but I can find no evidence of
anyone or anything that was invoking the job other than its own schedule.
Once I disabled the schedule it stopped.
"Narayana Vyas Kondreddi" wrote:
> Disabling the job should be fine. Can you check the history and see who is
> invoking it? Could it be that there's another job that runs this job using
> sp_start_job?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
> "Jon Goughnour" < JonGoughnour@discuss
ions.microsoft.com> wrote in message
> news:DC301B21-E312-44F4-8B72- EF883EF19913@microso
ft.com...
> have
>
>
>
| |
| Yogish 2005-06-30, 3:23 am |
| Hi,
After you have disabled the job, probably you could have checked "enabled"
column in sysjobs against this particular job, to see if its really been
disabled.
But its quite strange though......
--
- - - - - - - - -
Thanks
Yogish
"Jon Goughnour" wrote:
[color=darkred]
> Yes, I was thinking that may be the case also but I can find no evidence of
> anyone or anything that was invoking the job other than its own schedule.
> Once I disabled the schedule it stopped.
>
> "Narayana Vyas Kondreddi" wrote:
>
| |
| Jon Goughnour 2005-06-30, 3:23 am |
| Yes, quite strange. I wish I would've thought to check sysjobs but
unfortunately I didn't. I'm going to play around with this a little more on
a test server. Thanks.
"Yogish" wrote:
[color=darkred]
> Hi,
>
> After you have disabled the job, probably you could have checked "enabled"
> column in sysjobs against this particular job, to see if its really been
> disabled.
> But its quite strange though......
>
> --
> - - - - - - - - -
> Thanks
> Yogish
>
>
>
> "Jon Goughnour" wrote:
>
|
|
|
|
|