Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Job stock

Author  Topic 

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-06-12 : 15:49:50
Hello:

I have the job stucked. I tried to stop this job from activity monitor but could not. I could not run this job. It said: this job is already running.

Is any idea how to run this job again?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-12 : 15:52:30
What is the job doing? Did you check sysprocesses to see if it's in a rollback status?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

snow12
Yak Posting Veteran

74 Posts

Posted - 2012-06-12 : 16:23:31
Dear Tara:

Do you have the query to check the sys process and how to determine rollback status?

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-12 : 16:31:22
Find your job in here:

select * from master..sysprocesses

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -