Hello:

I run this script

SELECT j.[name],

s.step_name,

h.step_id,

...

Thanks.

Is any script to get detailed failed job step a week ago from sys archive table like view history gui

Yes. Thank you very much!