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
 General SQL Server Forums
 New to SQL Server Administration
 Job Activity Monitor "Enabled" column

Author  Topic 

edyl
Starting Member

35 Posts

Posted - 2011-06-27 : 11:09:31
Hello Everyone,

In Management Studio’s Job Activity Monitor, I see a job that should run regularly, disabled (Enabled = no). Does this mean that it will not run automatically in its regular schedules? This is a job that runs a transact SQL command “EXEC dbo.some_procedure”, and this procedure should run every hour.

Also what does the column “Status” means? I see all the jobs that shows up as “Idle” in this column. Is this the column that tells me if the job is currently running or not?

Any insights greatly appreciated.

Thank you.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-06-27 : 11:27:05
I see a job that is disabled (Enabled = no).
Does this mean that it will not run automatically in its regular schedules?
Yes, you are right.

What does the column “Status” means?
It is the current status of the job ie. running in this moment or not (idle).
(maybe the Monitor needs a click on the refresh-button...)


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -