I have tested the code and it is giving an error. I think end statement is not required at the last line, just comment that out and it works

Excellent topic!

I just want to add one thing. If you use table variable or tmp table use all column names instead of just * in select statement.

Forexample:

Does not Work

select *...

Yes you can create a SSIS package for your requirements. use Execute task run the Get Login Script and then Script Task to send emails. after creating package create a...