sql server dts: DTS Package scheduled to run as job never runs -- sql server dts

RE: DTS Package scheduled to run as job never runs

kphelps NO[at]SPAM oceanspray.com
2/21/2004 4:39:06 PM

Russ,
There is no job history. When I click on view job
history... There is no job history information for this
job. For more information.
Thanks for helping.

Katherine

[quoted text, click to view]

Re: DTS Package scheduled to run as job never runs

Darren Green
2/24/2004 7:26:04 PM

In message <138a801c3f89b$c3a97d70$a101280a@phx.gbl>,
"Kphelps@oceanspray.com" <anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

Double check that the job schedule is enabled. Often the job is fine
itself, enabled and all that, but the schedule has become disabled.

If this is the case and it re-occurs try changing the end time slightly.
Add or subtract minute, ,e.g. use 20:59 as opposed to 21:00 for the end
time.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Re: DTS Package scheduled to run as job never runs

Katherine Phelps
2/25/2004 2:01:09 PM

I finally called MS support for help. The solution was this
A start and stop of the SQL Server Agent cleaned up the SQLAgent pending notification which had been exceeded (max 128).
I have no cause as to how this happened nor did they.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.