I want to use the stored procedure xp_sendmail but in some cases I don't want to have a @Query, just send a mail.
But if I omit the parameter @query (as I thought I could) I get this message:
xp_sendmail expects parameter @query, which was not supplied.
My executionline looks something like this:
exec master.dbo.xp_sendmail @RECIPIENTS= 'Firstname.Lastname@company.se',@Message='Some message here..',@NO_HEADER = 'TRUE', @subject = 'My subject'