Show Job Run Snapshot

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQL_Kills Hall of Fame Points: 3154 More actions · Answer 1

Tried running the stored procedure

EXEC dbo.spShowJobRunSnapshot('9/16/2012', '9/16/2012 23:59')

But I get the follow Error Message:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '9/16/2012'.

Monte Kottman Ten Centuries Points: 1385 More actions · Answer 2

Try:

dbo.spShowJobRunSnapshot '9/16/2012', '9/16/2012 23:59'

SQL_Kills Hall of Fame Points: 3154 More actions · Answer 3

Hall of Fame

Points: 3154

September 26, 2012 at 9:34 am

Doh! Thanks

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

May 9, 2016 at 1:17 pm

Thanks for the script.