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.
| 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. |
 |
|
|
|
|
|
Job Activity Monitor "Enabled" column