Post reply

Disabled Snapshot Agent job ran anyway.

  • June 1, 2011 at 8:10 am

    #251839

    Hey all,

    I put together an new process to take the place of a Snapshot replication job from server A to server B. Last night I disabled the snapshot agent job and the distribution agent job, but the snapshot ran anyway.

    Any thoughts?

    P.S. the schedules for each agent job were not disabled, but that shouldn't matter if the job it's self is disabled, correct?

    Thanks,

    DK

  • June 1, 2011 at 9:15 am

    #1332558

    Do you have another job that executed that snapshot job?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 1, 2011 at 11:05 am

    #1332635

    SQLRNNR,

    Thanks for your reply. I can not find any other agent job that is calling this snapshot agent job. Any ideas?

    Thanks again,

    DK

  • June 1, 2011 at 11:42 am

    #1332675

    What do you see in the job history for that particular job?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 1, 2011 at 12:48 pm

    #1332713

    I see a typical run of the job, as if nothing had changed. All the step start and complete.

  • June 2, 2011 at 1:58 pm

    #1333376

    Thanks for the help, it did not run at the next scheduled time. I disabled the schedule, but other than that made no other changes. Not sure if disabling the schedule had any effect. But, it is not an issue anymore.

    Thanks again,

    DK

  • June 2, 2011 at 2:13 pm

    #1333387

    Good - that is a bit bizarre.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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