EXEC msdb.dbo.sp_send_dbmail @profile_name = 'U4 Notifications.com' ,@recipients = 'firstname.lastname@example.org' ,@subject = 'Circuits missing a CLLI Code - Process Z4026 - "Garbage man cometh"' ,@attach_query_result_as_file = 1 -- can go to 32767 for query width ,@query_result_width = 32767 ,@body_format = 'TEXT' ,@body = 'blah blah blah test message ' ,@append_query_error = 0 ,@exclude_query_output = 0 ,@query_no_truncate = 0 ,@query = 'SELECT ANI = Left(ANI,12) FROM [Billing Automation Processes].dbo.[Z4026 - Circuits missing CO information]'
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.