Post reply

Job does not fail... but does not work?

  • November 6, 2008 at 2:46 am

    #193486

    Hi,

    I have set up two jobs that run stored proceedures on the SQL agent. These jobs run on a daily schedule, and always report that they have succeeded.

    However, when I check the results, it is clear the proceedures have not run.

    I can run the stored proceedures fine. I can also select "start at step" and run the agent job without any problems - just the schedule doesn't work.

    I have also setup the agent to run on my account to check if it's a permission issue, and I have the same problem.

    Any advice appreciated.

  • November 6, 2008 at 3:48 am

    #894746

    Hello,

    What results are you getting in the Job History? Can you post a sample?

    In the Advanced Settings for a Job Step there is the option to save all the step's output. That might help diagnose the issue. (Please see BOL Topic – “Job Step (Advanced Tab)”)

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 2 posts - 1 through 1 (of 1 total)

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