gianitoo
asked on
help with notification email syntax
i am trying to send an email if this query below has matches. i get an error. could you help to make sure i have all single quotes
IF EXISTS (SELECT 1
FROM legalcontract
WHERE (expired = 1) AND (Triggerdate >= CONVERT(varchar(10), GETDATE(), 121)) AND (Triggerdate <= DATEADD(day, 90, CONVERT(varchar(10), GETDATE(),
121)))
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'gbarraza@jus tmarketing .com'
,@body='Message Body'
,@subject ='Message Subject'
,@profile_name ='JMI'
IF EXISTS (SELECT 1
FROM legalcontract
WHERE (expired = 1) AND (Triggerdate >= CONVERT(varchar(10), GETDATE(), 121)) AND (Triggerdate <= DATEADD(day, 90, CONVERT(varchar(10), GETDATE(),
121)))
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'gbarraza@jus
,@body='Message Body'
,@subject ='Message Subject'
,@profile_name ='JMI'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what error?