Hi,

did u checked ur regional settings ??

i believe if you want to convert to the format yyyymmdd then the tsql should be like

SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD].

if you are stll gettingthe error you...

Please post the error you are getting

http://www.microsoft.com/sqlserver/en/us/product-info/previous-versions.aspx

Its running fine when executed manually

its not an issue wth db mail ..the error shown doesnt seems to be the right one. The db mail hasnot configured in that instance.