How to kill a backup job which is running?

[Former Member]

Hi All,

We have SQL Server 7.0 in which we have scheduled a periodic job for taking a backup of the database every night. It was working fine. Today the job was running for more than a day which should generally be an hour.

I found that this is happening as another job is trying to access the same database which works as a lock management prolonging the repeated job. I am now trying to kill the periodic backup job which is running which I couldn't.

Every other job that I have tried to kill was successful. But I am unable to kill this job (even by right clicking the job and selecting KILL/STOP). Can someone help me to manually kill this job without restarting the database?

Thanks

Vijay

[markus_doehr2 · Accepted solution]

in SM50 check the process ID of the job, then use the task manager to kill the corresponding "disp+work.exe" with that specific process ID.

--

Markus

[Former Member]

Hi

I have scheduled this database backup job directly through SQL Enterprise Manager. So, I will not be anle to view this job running through SAP.

Please guide me with steps to kill the job through O/S or through DB directly.

Thanks

Vijay