How to the inconsistency in the job status?

  • When I checked the Job Activity Monitor, I could not see the job is running (It was marked success from the previous run). When I viewed its history, I saw the job was in progress.

    How to fix this issue?

    Many thanks in advance.

  • Hi,

    are you sure that there is no session open by the job? Why did the job is canceled without changing the state? Perhaps an entry in the sql error log?

    Please check the sysprocesses-dmv (look after program_name column with sql agent description) to ensure, whether the job is running or not.

    Greets,

    Patrick

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

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

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