can you please tell me how you created an account and granted it the sqlagent role

Thanks Chris..

Please can any body help

insert both the values in Col1 and col2 from table1 to col1 and col2 in table2

yes, it is done through scripts.. but the problem is it is coming from a table with identity column and getting inserted to a table with identity column.. this is...