Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    23

    Unanswered: Daily scheduled job has its schedule disabled despite successful completion

    I have a job which is scheduled to run once daily. The job is enabled and the schedule is also enabled. After the job runs (successfully), the schedule has its 'Enabled' flag reset (i.e. the 'Enabled' checkbox in the schedule properties has become unchecked) and so is not rescheduled.

    I have other jobs configured in a similar way, but they are run and then rescheduled in the normal way without any problems.

    What could be going on?

  2. #2
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34

    Question

    I'm sure you'd know but there is definately no disables step in the job?
    e.g
    EXEC sp_update_job @job_name = 'bla bla',
    @enabled = 0

  3. #3
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34
    This may be of some use to you. Have you checked the logs?

    http://support.microsoft.com/default...&Product=sql2k

Posting Permissions

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