Hi, Pls find below script, which I'm using
USE [master]
GO
EXECUTE msdb.dbo.sysmail_stop_sp;
EXECUTE msdb.dbo.sysmail_start_sp;
begin
set nocount on
DECLARE @Recipients varchar(275)
DECLARE @Subject varchar(275)
DECLARE @Body varchar(MAX)
DECLARE @server varchar(25)
DECLARE @idx int, @status varchar(25), @DB...
Attachments:
You must be
logged in to view attached files.