Print Directly to Printer

SQL Server Administration
1

Good morning, everyone.

Using an Agent job, is it possible to directly output the results of a query to a specific printer/print queue?

I read that I can invoke PowerShell such as: Invoke-Sqlcmd -Query "SELECT * from dba..test_data;" | Out-Printer

The report is currently emailed in HTML format but they also want a hard copy to print automatically.
(We are not using SSRS)
Thanks for any ideas.

2

You read correctly. if you run that command it will send directly to the connected printer