Job Duration Unusual - 63368067476.44 s

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Job Duration Unusual - 63368067476.44 s

Postby PDinCA » Wed Jan 21, 2009 3:19 am

Twice in six hours the same Job, which is kicked off by a SQL Alert on sp_user_counter1 > 0 is being reported as started at 1/1/0001 12:00:00 AM.

I can send a Word doc with screenshots of the latest occurrence with the Job History that shows a 19 second duration and a correct start time.

Posts: 534
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Matthew Flatt » Fri Jan 23, 2009 10:44 am


I apologise you are encountering issues with SQL Response.

If you could send all the information you have to quoting reference F0018807 that would be great.

Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

Postby PDinCA » Fri Jan 23, 2009 6:43 pm

File sent. Thanks.

Issue occurs with reasonable frequency - 19 times in the last 3 days.
Posts: 534
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Emma A » Fri Apr 24, 2009 10:12 am

Hi PDinCA,

Thank you for providing us with this information we have replicated the problem and it should be fixed in a future version.

Best Wishes
Emma A
Posts: 40
Joined: Mon Mar 30, 2009 2:53 pm

Job duration unusual

Postby TobiJ » Thu Oct 14, 2010 2:45 pm

I created a SQL Server Agent Job (CmdExec type) that executes a batch file. Everytime the job executes which is nightly at 8:00pm, I get Job duration unusual alert with "Job started at: 1/1/0001 12:00:00AM". I am running SQL Response V1.3.0.58.

I have not found anything helpful online or in this forum. Is any one else having this problem or fixed this problem?

Posts: 1
Joined: Thu Oct 14, 2010 1:57 pm

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests