Post reply

Reschedule I once off Job

  • June 2, 2008 at 2:20 am

    #125529

    Hi

    I created a job to run once. I run fine. two weeks later I reschedule the same Job Its did run there's no error. The job is anabled every thing is setup correctly. What could be a reason its did run the second time? Does anyone know?

  • June 2, 2008 at 2:37 am

    #822800

    Please clearify:

    1 You create a new job

    2 You schedule the job to run once

    3 The job runs without error

    4 You re-schedule the job to run once (again)

    5 The job runs (again) without error

    What is your question?? If above is true then it all runs as expected....

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 2, 2008 at 2:56 am

    #822801

    1to 4 is correct the problem is after the reschedule the Job didn't run at the time that was stated, ity didn't run at all.

  • June 2, 2008 at 3:08 am

    #822808

    Hi

    what is the error that u got. did u check the error logs for the error details ?

    "Keep Trying"

  • June 2, 2008 at 3:08 am

    #822809

    Check whether your SQL Server Agent is running or not.

    You can do this by:

    Start->Programs->Service Manager, select Sql server agent from services dropdown and press Start button.

    -Regards

    Satya N Tailor

  • June 2, 2008 at 3:09 am

    #822810

    Maybe obvious, but

    - did you enable the job (checkbox on: job properties - general)

    - did you enable the schedule (checkbox on: job properties - schedule - edit)

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 2, 2008 at 3:20 am

    #822814

    Thanks a lot guys.

    HanShi u are correct, I just checked everything was setup fine except for Schedule properties was not Enabled.

    Thanks again.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply