Disabled job continues to run

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,
JonDisabling 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@.discussions.microsoft.com> wrote in message
news:DC301B21-E312-44F4-8B72-EF883EF19913@.microsoft.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|||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@.discussions.microsoft.com> wrote in message
> news:DC301B21-E312-44F4-8B72-EF883EF19913@.microsoft.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
>
>|||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:
> 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@.discussions.microsoft.com> wrote in message
> > news:DC301B21-E312-44F4-8B72-EF883EF19913@.microsoft.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
> >
> >
> >|||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:
> 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:
> > 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@.discussions.microsoft.com> wrote in message
> > > news:DC301B21-E312-44F4-8B72-EF883EF19913@.microsoft.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
> > >
> > >
> > >