I guess I shouldn't have asked the question, as it isn't pertinent to the issue. I'm trying to find out why my user is 'broken' now, will post back...

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...

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...