Thank you very much

its very helpful nd finally it is done.

shweta

hi yes i tried to send mail through that but when i check it by the query

select * from sysmail_allitems

i got the status failed or undent

and yes as per...

well thanks agin for your concern ya i check it through

SELECT * FROM msdb.dbo.sysmail_allitems

WHERE mailitem_id = 9 ;

and i got the status fail ane the...

thanks for your reply.

but i already configured database email through wizard and create a new sqljob but somehow i dont get the emails so as u described i send a...