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?
