SQL Server Performance Forum – Threads Archive
Time in DB Maintenance report Mail.We are using DB Maintenance planner for daily backups and also we have
scheduled email notification to my boss. In the report it is displaying
message like this Subject: SQL Server DB Maintenance Report – TESTLINXDB Maintenance Plan2 (Success) The attached report is a summary of the automated maintenance carried out for plan Saturday 31 May 2003: He want the time with the date in the above report.
i.e Saturday 31 May 2003 + time How i can accomplish this job. Pl suggest. Rushendra
I believe its pre-defined setting on maint.plans.
You can add another step to accomplish the task with GETDATE() function. _________