How can we help you today? How can we help you today?

Job Duration Unusual - 63368067476.44 s

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
PDinCA
0

Comments

4 comments

Sort by
  • 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
    0
  • PDinCA
    File sent. Thanks.

    Issue occurs with reasonable frequency - 19 times in the last 3 days.
    PDinCA
    0
  • 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
    Emma A
    0
  • 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...
    TobiJ
    0

Add comment

Please sign in to leave a comment.