I have a Microsoft SQL 2000 server which early each morning runs a host of jobs which append transaction data to a transaction data warehouse. On a Saturday morning the 8th the jobs failed to execute due to a network failure and according to the SQL Enterprise\SQL Server Agent\Jobs window the next run date was the 9th. Well it's Monday the 10th, the jobs have not attempted to run since the 8th and it still shows then next run date as the 9th. The Server Agent is running and the daily SQL backups have continued to run as scheduled. Does anyone know why the jobs, scheduled to run daily, are not at least attempting to do so?
Thanks for your helpHowdy
WHat version of Service Pack are you running on the server? Should be 3A if you can...
Cheers,
SG.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment