Thanks Alvin. But shouldn't the 'Local System' account have enough privileges to run the job?

http://msdn.microsoft.com/en-us/library/ms143504.aspx

I changed the job owner to 'sa' (from my domain account) and it ran correctly....

I found that the email account that I was using to try and send email was not configured properly. Found this out by talking to my email admin. ...

Could be a bug:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/6f143ca9-d08c-4028-9fef-58ae62ae5fc6

I'm going to follow up with Microsoft.

Thanks Jeff. But as I stated, that area was changed to email me and I've yet to see any email. Also, when I look at the properties of...

Found an answer for question number 2:

https://metalink2.oracle.com/metalink/plsql/f?p=130:14:2551972738979005909::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,466228.1,1,0,1,helvetica

Thanks for the input, Lynn. It doesn't appear to be a problem to mismatch those column definitions, based on some tests I did, though:

create table test_n_id2

(

n_idvarchar(20)

)

----------------------------

insert into test_n_id2

select

national_id

from...