yes, that's what I thought too. I don't believe we can get the runtime without having the job completes first.

i'm getting !Job "Accounts_from_app03" did not run at all on 04/23/2015!

still not getting the current runtime after the changes

Declare @body varchar(100)

Select @body ='accounts_from_app03' + Case When jh.run_status = 1 Then '' Else '!UN' End +

...

Thanks SScrazy. I really appreciate your help with this.

Now, I've stumbled on another issue. Since i'm including this the last step of the job here. I don't think i'll be...

THANK YOU ALL for all the help! both suggestions work perefectly. Thanks again.

Thank you Laurie..but how do i modify this so i can pull all the other records in that column? Thanks in advance:-)