Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to the inconsistency in the job status? Expand / Collapse
Author
Message
Posted Saturday, February 23, 2013 1:15 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314
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.
Post #1423371
Posted Sunday, February 24, 2013 7:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:29 AM
Points: 244, Visits: 476
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


Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1423415
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse