Disable a job schedule

13 Dec 2005 12:18 AM

Lynn

Hi,

I have a job with three steps and four schedule time per day.

I schedule a job to disable one of schedule time, such as 5:00PM schedule.
The job is still enable, but this schedule time show enabled =NO before
5:00PM. However, the 5:00PM schedule still run regardless schedule
enabled=NO.

Is this flag in sysjobschedules play any role for enable and disable a
schedule? Or, I have to disable and enable from the job level (sysjobs).
Please advise.

--
Best Regards,

Lynn

13 Dec 2005 1:33 AM

Lynn

Hmm, I disable job in the job level (sysjobs) at 4:45PM and the 5:00PM
schedule is enabled. And, the job still run at 5:00PM even though the job is
disabled. I don't understand what's wrong in my procedure. From the
Enterprise Manager, I see the job was disabled.

Looks like either way (from job level or schedule level) won't work.

Please help.

--
Best Regards,

Lynn

Show quote

"Lynn" wrote:

> Hi,
>
> I have a job with three steps and four schedule time per day.
>
> I schedule a job to disable one of schedule time, such as 5:00PM schedule.
> The job is still enable, but this schedule time show enabled =NO before
> 5:00PM. However, the 5:00PM schedule still run regardless schedule
> enabled=NO.
>
> Is this flag in sysjobschedules play any role for enable and disable a
> schedule? Or, I have to disable and enable from the job level (sysjobs).
> Please advise.
>
> --
> Best Regards,
>
> Lynn