InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 20:41:40 GMT20http://www.sqlservercentral.com/Forums/Topic1423371-391-1.aspxHi,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,PatrickSun, 24 Feb 2013 07:17:22 GMTPatrick_Fiedlerhttp://www.sqlservercentral.com/Forums/Topic1423371-391-1.aspxWhen 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.Sat, 23 Feb 2013 13:15:35 GMTSQL ORACLE