Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Job Enabled and Schedule Enabled confusion
17 posts, Page 1 of 2
1
2
»»
Job Enabled and Schedule Enabled confusion
Rate Topic
Display Mode
Topic Options
Author
Message
phrankbooth
phrankbooth
Posted Thursday, February 05, 2009 8:24 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:16 PM
Points: 24,
Visits: 159
Hello,
I can't seem to reconcile this and can't find a clear explanation on it.
I have a Job set up with a Recurring schedule.
When both Job and its Schedule are Enabled, the Job will run normally.
When Job is Enabled but Schedule isn't, the Job will not run.
When Job is Disabled but the Schedule is Enabled, the Job runs.
I don't get how the Job can be Disabled yet still run when its Schedule is Enabled.
What is the purpose then of Enabling a Job is the Schedule is what controls if it runs or not?
Thanks!
Post #650924
homebrew01
homebrew01
Posted Thursday, February 05, 2009 8:50 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 11:16 PM
Points: 2,554,
Visits: 7,208
phrankbooth (2/5/2009)
Hello,
I can't seem to reconcile this and can't find a clear explanation on it.
I have a Job set up with a Recurring schedule.
When both Job and its Schedule are Enabled, the Job will run normally.
When Job is Enabled but Schedule isn't, the Job will not run.
When Job is Disabled but the Schedule is Enabled, the Job runs
.
I don't get how the Job can be Disabled yet still run when its Schedule is Enabled.
What is the purpose then of Enabling a Job is the Schedule is what controls if it runs or not?
Thanks!
".. When Job is Disabled but the Schedule is Enabled, the Job runs.."
Sounds wrong .... Are you sure about that ??
Post #650951
phrankbooth
phrankbooth
Posted Thursday, February 05, 2009 9:01 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:16 PM
Points: 24,
Visits: 159
I'm absolutely sure about it. I ran a Trace on it.
Post #650964
homebrew01
homebrew01
Posted Thursday, February 05, 2009 9:46 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 11:16 PM
Points: 2,554,
Visits: 7,208
I've never encountered that. It shows disabled in the GUI ? Does the "Last Run" get updated afterwards ?
If you look at the "enabled" field in msdb..sysjobs, what do you see ?
Post #651025
phrankbooth
phrankbooth
Posted Thursday, February 05, 2009 12:10 PM
Grasshopper
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:16 PM
Points: 24,
Visits: 159
GUI and DB settings are as expected.
I have done manual runs atkleast 10 times and same results, Schedule must be Disabled to stop Job.
Post #651168
Jon.Morisi
Jon.Morisi
Posted Tuesday, April 20, 2010 9:42 AM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275,
Visits: 679
I'm having the same issue, job disabled, schedule enabled, job runs.
(I'm running sql 2008 sp1)
My jobs were created via a maintenance plan, were yours too?
Post #906987
Jon.Morisi
Jon.Morisi
Posted Tuesday, April 20, 2010 10:03 AM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275,
Visits: 679
Try restarting sql server agent service after disabling the job...seems to work for me.
Post #907012
Lynn Pettis
Lynn Pettis
Posted Tuesday, April 20, 2010 10:09 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 21,602,
Visits: 27,431
Are you disabling the job via the GUI or code? If code, please show the code.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #907016
Jon.Morisi
Jon.Morisi
Posted Tuesday, April 20, 2010 10:27 AM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275,
Visits: 679
GUI
Post #907045
homebrew01
homebrew01
Posted Tuesday, April 20, 2010 11:36 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 11:16 PM
Points: 2,554,
Visits: 7,208
You can generate the code. Open the job, uncheck the "enabled" button, then "Script to new window"
I can't replicate that in 2005. Tried a "regular" job and a maint plan job. Don't recall it ever happening either.
You could query these tables for that specific job and see what the enabled values are:
sysjobs
sysjobschedules
sysschedules
Post #907112
« Prev Topic
|
Next Topic »
17 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.