Thats what I want to do. It is really hard to get a window to do it in my production.

I did in one of my test servers, and it works....

mccork, thanks for your reply. I created an instance in my local computer (win prof os), and connected to the same sun solaris oracle server. I have oracle81 client in...

Guess what.. I tried inserting one row to the oracle table from QA, it is taking 7 mts.

Is MSDTC service really slow in handling orcle transactions?

By the way, the Orcle server is in Unix solaris, in the network.

Actually, after the cold reboot, we were able to connect to oracle, and view thru EM.

I am not sure, why everytime when we have problems, we have to reboot the...

The log says:

The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x25388148

Thanks in advance for your help

Thanks for the info. I will try.

What and where is BOL ? I see everyone talking about it in this board.

Yes the agent was setup as manual startup, and we had a abnormal shutdown.

I use win2k. Anyone faced a similar problem, and found a solution to this?

CAn you tell what you did?

It works finally. Thanks much !!!

My jobs were sending mails, since it was using agent service. In this server, these 2 services were under different account.

xp_sendmail uses sqlserver service....

Never mind. It works. My if condition before xp_cmdshell was wrong. Sorry false alarm.

Also, I am trying to run the same thing in production, it gives me an error like this:

xp_sendmail: Procedure expects parameter @user, which was not supplied.

Any help will be greatly...

Cool it works! Thanks! But i have more questions. it takes more than 30 mts to backup 850mb. But i have every 15mts tran dump. While I am...

Thanks Allen. My administrator told me to use \\servername\e$ drive to use it.I could copy files to this drive using batch jobs.

But, my backup plan is not able to...

Allen, if edison is the server and E is the drive, the backup should be to:

\\edison\E$\backup\sales.BAK. right? How do i check if SS services account is able to write...