Thanks for the reply.

That does answer question 2.

A bit of a hassle just to get the database name for various actions but I suppose it might be easy to set...

Thanks very much for the replies and help

I have found that if I log to a table as suggested and then after the job has run for the first time click on 'view' and then the output...

Maybe this answers my question!!

http://msdn2.microsoft.com/en-us/library/ms191142.aspx

To view job step output

In the Job Step Properties dialog, click the Advanced page.

Depending on the version of SQL Server you are connected...