I have to set up a sql job that sends an email
"This is to test that today is 02/11/2013 and it is a good day"
@recipients = 'firstname.lastname@example.org,
@subject = 'Test',
'This is to test that today is 02/11/2013 and it is a good day'
Is there any way that whenever the job runs it puts the current date with
"SELECT CONVERT(VARCHAR(12),GETDATE(), 101)"