O.K.  After hours and hours of searching the internet, I came to the conclusion it was a Windows fault not SQL.  Any Windows accounts that were created earlier, worked fine...

I'm soooo stupid.  I must of deleted it by accident with all the of cutting and pasting and didn't even notice. Thanks for that.

I've put the following

IF EXISTS (SELECT * from db1.dbo.view1 WHERE           

(db1.dbo.view1.date >= dateadd(hh,-24,getdate()))

BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'krha',

@recipients = 'kris@work.com.au',

@query = 'SELECT * from db1.dbo.view1              ...

Thanks for that.  That worked perfectly.

I hate to be a pain.  But I now need an IF clause.  If there is no new data don't send an e-mail.  Can you...

That's what I want to do but I'm not sure of the syntax due to it being a timedate statement.

I've actually refined the script a little as below:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'krha',

@recipients = 'kris@work.com.au',

@query = 'SELECT * from db1.dbo.view1' ,

@subject = 'email',

@attach_query_result_as_file = 1

I was hoping someone...

Does the first select statement ever change?  If not you could create a temp table or maybe better a view and just run the one select statement.

Just a suggestion

Your not going to believe it.  Obviously the Christmas break wasn't enough for me.  I had a typo in the e-mail address

Still the...

O.K I've had a play around with this and my question is now.  When I run the script, it says that the mail queued.  According to BOL that means it's...

I'm using 2005.  The storedprocedure was the way I was going for.  Then I could (as you say) create a job to run everynight.  I already have several e-mails that...

Cool thanks it's all working with sqlcmd -S Server\Instance -i d:\sql_scripts\script.sql -o\\server\folder\File.CSV -s "," -h -1 -W

I've got the script working by doing: sqlcmd -S Server\instance -i "D:\SQL_Scripts\Script.sql" -o "\\server\folder\file.CSV" -s"," - h-1 -W

However I can't get SQL to automate the job.  It keeps coming...

I ran this script and got a syntax error.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'E'.

Like you, I'm not very good with Integration Service yet so I'm trying to avoid it at the moment as this is urgent.

Can you give me an example of the...

I've figured out how to do it for individual jobs by going to the properties of the auto job and choosing Steps - advanced, but it exports too much infomation. ...