I take it you have used SQL Server Agent to scheule the SSIS package?

If so, please confirm the following:

When you imported the Package under Intergration Services what did you...

thanks Derek, worked well!

Thanks Guys,

Im how would the whole exspresion look?

In regards to my code posted abouve?

Nope! :crazy:

Thanks but that does not work

thanks but its not af all detailed, just says 'SendMail failed'

How do I set up the error logging in SSIS?

I also found this information:

McAffee Virus Scan Enterprise was running on the Server and by default is configured with 6 port...

Thanks,

IS there any log files I can create for send mail in SSIS?

When I run the SSIS task the only error I get is:

Error: 0xC002F304 at US Trades, Send Mail Task: An error occurred with the

following error message: "Failure sending mail.".

Error:...

Sorry im a bit lost!

Currently I use Database mail (sp_send_dbmail ), to execute an SP then email the results this run at 10am everyday.

exec msdb.dbo.sp_send_dbmail

@profile_name = 'EMail',

@recipients='example@examplemail.co.uk',

@subject ='Test...

Thanks for the info.

Basically what I really want is to create a new table with the information from msdb and the query I have posted, therefore I can search one...

Ok i lied, iv got the Job History thanks!!!

Ok so far I can see 3 tables which help:

sysjobhistory

sysjob

sysjobschedules

joing them together im getting some good data but missing the most important 'Error Message'

i.e. I need the information describled in...

Yes the jobs are sql agent jobs.

Let me check the msdb..

Thanks

That looks much better thanks il try it!