The subject of the database mail sent when the Job Completes through sql agent notifications is getting truncated when sent to mobile phones.
Example:
Subject as received on Normal Mail = SQL Server Job System: 'SSIS19113_ETL' completed on \\LXML119
Subject as received on Mobile Phone = SQL Server Job System: 'SSIS19113_ETL' c
I believe that the limitation for subject in mobile phone is 40 characters.
As you can see the server name is truncated.
Is there any way i can modify the message to remove the string 'SQL Server Job System' or have my own subject like " Job SSIS19113_ETL on \\LXML119 Completed "