Ideally, I need to be able to define a Jenkins job that simply emails the results of a sql query to a list of users. Using the script runner plugin, it ends up sending an email that contains a link, which when the user clicks it, they then have to know to click "Console Output", and then they can see the results.

I simply want the job to produce the sql query results and make it possible for me to send them somewhere.

I guess I'll have to write a custom pipeline to do what I really need.