enable job results in a sp_send_dbmail error
0
votes
0
answers
121
views
On one of our production servers (SQL SERVER 2017 Enterprise) I get the following error whenever I right click and enable a Job in the SQL Server Agent:
Alter failed for Job 'My Job'. (Microsoft.SqlServer.Smo)
...
At least one of the following parameters must be specified. "@body, @query, @file_attachments, @subject". (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.3162&EvtSrc=MSSQLServer&EvtID=14624&LinkId=20476
------------------------------
Server Name: MyServer
Error Number: 14624
Severity: 16
State: 1
Procedure: msdb.dbo.sp_send_dbmail
Line Number: 242
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
The Agent user is a sysadmin. I'm able to send a mail using the procedure and the mail profile found in the agents Alert properties. I'm not sure what else to check. Has anyone else run into this?
Asked by Lumpy
(2129 rep)
Nov 18, 2021, 08:01 PM