Post reply

Warning messages in SQL Agent log to deactivate job schedule

  • December 6, 2011 at 12:38 pm

    #253035

    I create a number dynamic jobs that only run one time.

    Is there anyway to suppress (or coding I could follow to address) these warning messages from the SQL Agent error log?

    SQL Agent log Message [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule

    I have tried to put an end date in the job schedule but that did not help.

    I am running SQL Server 2008.

  • August 15, 2016 at 9:47 am

    #1895480

    I know this topic is old but did you ever find an answer for this? I have the same situation and I was trying to suppress those messages in the log, too.

  • August 15, 2016 at 9:53 am

    #1895482

    When do you get those messages - is it when you try to disable the job schedule from within a jobstep in the job? Why not just set the schedule to run one time instead?

    John

  • August 15, 2016 at 10:12 am

    #1895486

    I have a job that runs every 15 minutes that checks a table in a given database for a date/time in the future. If it finds a future date/time, it sets the schedule for a job associated with that database. This allows developers to schedule their own times for a process to run. Once the newly scheduled job runs, it then disables the one time job and adds the following to the Sql Agent log:

    [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 35

    This is not a big deal and I can rework this process but I was hoping there was a simple was to disable these messages.

Viewing 4 posts - 1 through 3 (of 3 total)

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