Re: SQL Server Agent job enable flag
From: Gert E.R. Drapers (GertD_at_SQLDev.Net)
Date: 12/24/04
- Next message: Florence Lee: "Re: error - microsoft jet database engine can not find the object tabble_name"
- Previous message: Shriniwas Tiwary: "Re: Disaster Recovery Planning"
- In reply to: Gary: "SQL Server Agent job enable flag"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Dec 2004 09:23:38 +0100
If that is the really the case it sounds like a bug to me.
GertD@SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Gary" <gld@hotmail.com> wrote in message
news:x4kyd.547229$wV.133718@attbi_s54...
>I am trying to understand the behavior of the enable/disable for sql agent
> jobs. It seems to behave differently for different jobs. For example, I
> have
> a set of say 10 jobs that are all currently disabled. For some of the
> jobs,
> manually selecting "Start job" seems to do nothing, the status remains Not
> Running and the Last Run Status shows success. Other jobs execute as if
> the
> enable flag did not exist. I realize there is also an enable checkbox for
> the schedule itself, so it seems odd to me that a disabled job runs in
> some
> cases but not in others. Looking at and comparing the job histories, those
> that don't run just show the time as 00:00 or 00:01 as the time for each
> step. This is not true for those jobs which seem to ignore the enable
> flag.
>
> Some jobs execute some ActiveX script as the first step, while other jobs
> execute T-SQL. I can't really find much of an explanation in the
> documentation about how this is supposed to work. The problem I'm trying
> to
> solve is to prevent disabled jobs from failing and causing alarms to be
> sent
> when they shouldn't be. There is also a runnable flag. Can't really tell
> what this is used for, I've never seen them show anything but "Yes" in
> this
> column.
>
> Is this a bug? Thanks for any advice.
>
> -Gary
>
>
- Next message: Florence Lee: "Re: error - microsoft jet database engine can not find the object tabble_name"
- Previous message: Shriniwas Tiwary: "Re: Disaster Recovery Planning"
- In reply to: Gary: "SQL Server Agent job enable flag"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
