How to the inconsistency in the job status?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 23, 2013 at 1:15 pm

  #394246

  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.

• Patrick_Fiedler

  SSCommitted

  Points: 1904

  More actions

  February 24, 2013 at 7:17 am

  #1590650

  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]