1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
declare @the_message varchar(1000)
declare @today_var varchar(10)
declare @var_name varchar(25)
set @today_var = convert(varchar(10),getdate(),103)
DECLARE table_cursor CURSOR FOR
SELECT name
FROM sysdatabases
where convert(varchar(10),crdate,103) = @today_var
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @var_name
WHILE @@FETCH_STATUS = 0
BEGIN
set @the_message = 'db name: ' + @var_name + ' on server : ' + @@servername
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'sqlmail',
@recipients = 'recipientMail',
@body= @the_message,
@subject = 'SQL Server Report - new database on SERVERNAME'
FETCH NEXT FROM table_cursor INTO @var_name
END
CLOSE table_cursor
DEALLOCATE table_cursor |
Partager