procedure to get mail for html file

DECLARE @attach varchar(1000)
SET @attach = 'E:\MSSQL\Healthcheck\report\Disk_'+ CONVERT (varchar,CONVERT (date, SYSDATETIME()))+'.html'
SELECT @attach

EXECUTE msdb..sp_send_dbmail
    @profile_name='TA-DRR',
    @recipients = 'Mail@xyz.com ;'Mail@xyz.com' ,
    @subject = 'diskspace report',
    @body_format = 'html',
    @exclude_query_output = 1,
    @append_query_error = 1,
                @file_attachments=@attach

Task Scheduler failed to launch action “C:\Windows\SYSTEM32\cmd.exe” in instance

Task Scheduler failed to launch action “C:\Windows\SYSTEM32\cmd.exe” in instance “{b6396338-9da0-44e3-b663-56556c7a9501}” of task “Archiver”. Additional Data: Error Value: 2147942667.

Follow the below steps to fix it-

1. Open the properties of the scheduled job

2. Go to Actions Tab

3. Edit the Action

4. Remove the double quotes (“) around the path provided in the filed “START IN (Optional)”

Scheduler fails because of the double quotes. Try to have no spaces in folder names.