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