Job Duration Unusual - 63368067476.44 s

[PDinCA]

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.

Version: 1.1.0.17

[Matthew Flatt]

Hi,

I apologise you are encountering issues with SQL Response.

If you could send all the information you have to support@red-gate.com quoting reference F0018807 that would be great.

Thanks.
_________________
Matthew Flatt
Test Engineer, HyperBac

[PDinCA]

File sent. Thanks.

Issue occurs with reasonable frequency - 19 times in the last 3 days.

[Emma A]

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

[TobiJ]

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?

Thanks...