Your answer is wrong or the syntax is wrong.  Your answer says that the go statement ends the context of the comment block and will still return an answer.  It...

Did you check to make sure your mail session was set up correctly in the SQL Agent? (right click on agent, go to properties, it's on the general tab)....

There is a syntax problem in the select statement. There is a ' after EmpNo=292'. Even though your answer would have been correct if not for the syntax...

You probably already thought of this, but try checking to see if other jobs are running at the same time your package is scheduled to run. Sometimes other jobs,...

I did not get an error message when I ran this query. I think your answer is wrong. The correct answer should be it only returns header data.