Urgent

[Sejal]

I've created one job which backsup all databases to tape drive
Hello,

I've a script in which the cursor is created on sysdatabases and gets db name and backup to tape, It is scheduled everyday
In view jobhistory it says on 19th job completed and doesnot show any history of 20th and 21st but in current Activity User NT AuthoritySystem database Model Status runnable Command Backup Database Application is SQLAgent- TSQL jobstep, I'm trying to kill it but when I refresh it is still there with runnable status
I don't understand how to stop this job

Pls anyone guide me

Thanks

Sejal

[ram]

Stop SQL Agent. Stop Job Restart SQL Agent. You have done now


------------
Sejal at 1/22/01 3:46:44 PM

I've created one job which backsup all databases to tape drive
Hello,

I've a script in which the cursor is created on sysdatabases and gets db name and backup to tape, It is scheduled everyday
In view jobhistory it says on 19th job completed and doesnot show any history of 20th and 21st but in current Activity User NT AuthoritySystem database Model Status runnable Command Backup Database Application is SQLAgent- TSQL jobstep, I'm trying to kill it but when I refresh it is still there with runnable status
I don't understand how to stop this job

Pls anyone guide me

Thanks

Sejal