I installed the Oracle client on the same drive where SQL Server is installed.

Yes i have been googled it several times but all in vain. ...thanks.

It is running in the sql server 2008 R2...i was testing if i could schedule a job to run a querry when the engine is started.

Thanks lowell,

I have been running the querry and then copying the result into an excel sheet and send as an attachement ...so other than sending it as html is there...