Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Question Unanswered: Daily jobs do not resubmit after failure

    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 help

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    WHat version of Service Pack are you running on the server? Should be 3A if you can....

    Cheers,

    SG.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •