Why would SQL jobs that are scheduled and enabled not run?
The really weird thing is that it is only some of the jobs, while the
other jobs on the server and some on the same databases run and report
fine?
*** Sent via Developersdex http://www.examnotes.net ***-Is SQL Server Agent running ?
-Do the job start if you start them manually ?
Jens Smeyer.
http://www.sqlserver2005.de
--
"Bill Orova" <kwiso@.msn.com> schrieb im Newsbeitrag
news:%23A3KqNfQFHA.248@.TK2MSFTNGP15.phx.gbl...
> Why would SQL jobs that are scheduled and enabled not run?
> The really weird thing is that it is only some of the jobs, while the
> other jobs on the server and some on the same databases run and report
> fine?
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Who owns the jobs that are running? Is this different from the owner of the
jobs that won't run?
Is there anything that the "bad jobs" have in common?
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Bill Orova" <kwiso@.msn.com> wrote in message
news:%23A3KqNfQFHA.248@.TK2MSFTNGP15.phx.gbl...
> Why would SQL jobs that are scheduled and enabled not run?
> The really weird thing is that it is only some of the jobs, while the
> other jobs on the server and some on the same databases run and report
> fine?
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
Showing posts with label enabled. Show all posts
Showing posts with label enabled. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
schedule not running though enabled
Hi,
I have actually enabled a schedule to be ran at every morning 3 am at first
it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
it "enabled" but it's still not running somehow
appreciate ur advise on what i can do w/o having to recreate the whole thing
(as it's part of the replication)
tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1maxzsim via SQLMonster.com wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at first
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
> it "enabled" but it's still not running somehow
>
"Could not be enabled" - can you elaborate a little? Why could it not
be enabled? Obviously there was something about it that SQL didn't
like, and by going around the safeguards like you did, you didn't fix
whatever that was.|||Hi
I assume that there are no entried in the history for this job and that is
why you don't think it has run?
Is the schedule set to have an end time that has expired?
John
"maxzsim via SQLMonster.com" wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at first
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
> it "enabled" but it's still not running somehow
> appreciate ur advise on what i can do w/o having to recreate the whole thing
> (as it's part of the replication)
>
> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1
>|||Hi,
Before i did the changes in the msdb database , i went into the scheule and
enable the schedule besides enabling the job but the schedule keep "disabling
itself" after i came out from the job
tks & rdgs
Tracy McKibben wrote:
>> Hi,
>> I have actually enabled a schedule to be ran at every morning 3 am at first
>> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
>> it "enabled" but it's still not running somehow
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||hi , it has been resolved
tks & rdgs
Tracy McKibben wrote:
>> Hi,
>> I have actually enabled a schedule to be ran at every morning 3 am at first
>> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
>> it "enabled" but it's still not running somehow
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||tks it's as per what you said i have dbl-checked and it's due to the fact
that there's an end time
tks & rdgs
John Bell wrote:
>Hi
>I assume that there are no entried in the history for this job and that is
>why you don't think it has run?
>Is the schedule set to have an end time that has expired?
>John
>> Hi,
>[quoted text clipped - 6 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1
I have actually enabled a schedule to be ran at every morning 3 am at first
it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
it "enabled" but it's still not running somehow
appreciate ur advise on what i can do w/o having to recreate the whole thing
(as it's part of the replication)
tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1maxzsim via SQLMonster.com wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at first
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
> it "enabled" but it's still not running somehow
>
"Could not be enabled" - can you elaborate a little? Why could it not
be enabled? Obviously there was something about it that SQL didn't
like, and by going around the safeguards like you did, you didn't fix
whatever that was.|||Hi
I assume that there are no entried in the history for this job and that is
why you don't think it has run?
Is the schedule set to have an end time that has expired?
John
"maxzsim via SQLMonster.com" wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at first
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
> it "enabled" but it's still not running somehow
> appreciate ur advise on what i can do w/o having to recreate the whole thing
> (as it's part of the replication)
>
> tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1
>|||Hi,
Before i did the changes in the msdb database , i went into the scheule and
enable the schedule besides enabling the job but the schedule keep "disabling
itself" after i came out from the job
tks & rdgs
Tracy McKibben wrote:
>> Hi,
>> I have actually enabled a schedule to be ran at every morning 3 am at first
>> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
>> it "enabled" but it's still not running somehow
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||hi , it has been resolved
tks & rdgs
Tracy McKibben wrote:
>> Hi,
>> I have actually enabled a schedule to be ran at every morning 3 am at first
>> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
>> it "enabled" but it's still not running somehow
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1|||tks it's as per what you said i have dbl-checked and it's due to the fact
that there's an end time
tks & rdgs
John Bell wrote:
>Hi
>I assume that there are no entried in the history for this job and that is
>why you don't think it has run?
>Is the schedule set to have an end time that has expired?
>John
>> Hi,
>[quoted text clipped - 6 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1
schedule not running though enabled
Hi,
I have actually enabled a schedule to be ran at every morning 3 am at first
it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
it "enabled" but it's still not running somehow
appreciate ur advise on what i can do w/o having to recreate the whole thing
(as it's part of the replication)
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1maxzsim via droptable.com wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
>
"Could not be enabled" - can you elaborate a little? Why could it not
be enabled? Obviously there was something about it that SQL didn't
like, and by going around the safeguards like you did, you didn't fix
whatever that was.|||Hi
I assume that there are no entried in the history for this job and that is
why you don't think it has run?
Is the schedule set to have an end time that has expired?
John
"maxzsim via droptable.com" wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
> appreciate ur advise on what i can do w/o having to recreate the whole thi
ng
> (as it's part of the replication)
>
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1
>|||Hi,
Before i did the changes in the msdb database , i went into the scheule and
enable the schedule besides enabling the job but the schedule keep "disablin
g
itself" after i came out from the job
tks & rdgs
Tracy McKibben wrote:
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||tks it's as per what you said i have dbl-checked and it's due to the fact
that there's an end time
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>I assume that there are no entried in the history for this job and that is
>why you don't think it has run?
>Is the schedule set to have an end time that has expired?
>John
>
>[quoted text clipped - 6 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||hi , it has been resolved
tks & rdgs
Tracy McKibben wrote:
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||maxzsim via droptable.com wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
>
"Could not be enabled" - can you elaborate a little? Why could it not
be enabled? Obviously there was something about it that SQL didn't
like, and by going around the safeguards like you did, you didn't fix
whatever that was.|||Hi
I assume that there are no entried in the history for this job and that is
why you don't think it has run?
Is the schedule set to have an end time that has expired?
John
"maxzsim via droptable.com" wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
> appreciate ur advise on what i can do w/o having to recreate the whole thi
ng
> (as it's part of the replication)
>
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1
>|||Hi,
Before i did the changes in the msdb database , i went into the scheule and
enable the schedule besides enabling the job but the schedule keep "disablin
g
itself" after i came out from the job
tks & rdgs
Tracy McKibben wrote:
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||tks it's as per what you said i have dbl-checked and it's due to the fact
that there's an end time
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>I assume that there are no entried in the history for this job and that is
>why you don't think it has run?
>Is the schedule set to have an end time that has expired?
>John
>
>[quoted text clipped - 6 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1
I have actually enabled a schedule to be ran at every morning 3 am at first
it could not be enabled so i went to "sysjobschedules" and "sysjobs" to make
it "enabled" but it's still not running somehow
appreciate ur advise on what i can do w/o having to recreate the whole thing
(as it's part of the replication)
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1maxzsim via droptable.com wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
>
"Could not be enabled" - can you elaborate a little? Why could it not
be enabled? Obviously there was something about it that SQL didn't
like, and by going around the safeguards like you did, you didn't fix
whatever that was.|||Hi
I assume that there are no entried in the history for this job and that is
why you don't think it has run?
Is the schedule set to have an end time that has expired?
John
"maxzsim via droptable.com" wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
> appreciate ur advise on what i can do w/o having to recreate the whole thi
ng
> (as it's part of the replication)
>
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1
>|||Hi,
Before i did the changes in the msdb database , i went into the scheule and
enable the schedule besides enabling the job but the schedule keep "disablin
g
itself" after i came out from the job
tks & rdgs
Tracy McKibben wrote:
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||tks it's as per what you said i have dbl-checked and it's due to the fact
that there's an end time
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>I assume that there are no entried in the history for this job and that is
>why you don't think it has run?
>Is the schedule set to have an end time that has expired?
>John
>
>[quoted text clipped - 6 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||hi , it has been resolved
tks & rdgs
Tracy McKibben wrote:
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||maxzsim via droptable.com wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
>
"Could not be enabled" - can you elaborate a little? Why could it not
be enabled? Obviously there was something about it that SQL didn't
like, and by going around the safeguards like you did, you didn't fix
whatever that was.|||Hi
I assume that there are no entried in the history for this job and that is
why you don't think it has run?
Is the schedule set to have an end time that has expired?
John
"maxzsim via droptable.com" wrote:
> Hi,
> I have actually enabled a schedule to be ran at every morning 3 am at fir
st
> it could not be enabled so i went to "sysjobschedules" and "sysjobs" to ma
ke
> it "enabled" but it's still not running somehow
> appreciate ur advise on what i can do w/o having to recreate the whole thi
ng
> (as it's part of the replication)
>
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200606/1
>|||Hi,
Before i did the changes in the msdb database , i went into the scheule and
enable the schedule besides enabling the job but the schedule keep "disablin
g
itself" after i came out from the job
tks & rdgs
Tracy McKibben wrote:
>"Could not be enabled" - can you elaborate a little? Why could it not
>be enabled? Obviously there was something about it that SQL didn't
>like, and by going around the safeguards like you did, you didn't fix
>whatever that was.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||tks it's as per what you said i have dbl-checked and it's due to the fact
that there's an end time
tks & rdgs
John Bell wrote:[vbcol=seagreen]
>Hi
>I assume that there are no entried in the history for this job and that is
>why you don't think it has run?
>Is the schedule set to have an end time that has expired?
>John
>
>[quoted text clipped - 6 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1
Subscribe to:
Posts (Atom)