December 18, 2008 at 10:20 am
Hello friends. I have a issue with the subject & body of the email being truncated when received on mobile.
The message shown below contains the mail received on general mail & on mobile.
This email is sent from sql agent using Notifications (Job Completes). I am not using EXECUTE [msdb].[dbo].[sp_send_dbmail] for this.
If you can notice the mail received on mobile does not have the server name in the subject .
STATUS & MESSAGES are missing in the body. I believe this is due to the limitation from the mobile carrier for messages.
Main Question: Is there a way i can edit the subject and/or the body of the email sent on Job Completion.
The reason i want to do that is that i would like to have the job name & server name in the first 40 char for the message and have status & message first in the body of the email.
Message as received on general mail --->
---------------------------------------------------------------------------------------------------------
SQL Server Job System: 'SSIS19113_ETL' completed on \\LXML119 ---> Subject of the mail
JOB RUN: 'SSIS19113_ETL' was run on 12/16/2008 at 11:00:00 PM ---> Body of the mail
DURATION: 2 hours, 33 minutes, 35 seconds
STATUS: Succeeded
MESSAGES: The job succeeded. The Job was invoked by User SSOL\AarmanRe. The last step to run was step 6 (Create Mobile Database). The job was requested to start at step 1 (Send mail reporting start of job).
---------------------------------------------------------------------------------------------------------
Message as received on mobile --->
---------------------------------------------------------------------------------------------------------
SQL Server Job System: 'SSIS19113_ETL' c
JOB RUN: 'SSIS19113_ETL' was run on 12/16/2008 at 11:00:00 PM
DURATION: 2 hours, 33 minu
---------------------------------------------------------------------------------------------------------
( Subject of the mail truncated to 40 char i.e. missing the server name, main body of the mail missing the STATUS & MESSAGES
FYI --->
SSIS19113_ETL: Name of the job
LXML119: Server name
SSOL\AarmanRe: Domain User name
Thanks in advance for any advices.
...Kumar
December 18, 2008 at 1:07 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply