Job Activity Monitor

Question

Job Activity Monitor

ramana3327

SSCoach

Points: 19722
More actions
January 5, 2016 at 3:48 pm

#303548

Hi,
We are using standard edition.
When I execute a job manually and try to see the job running status from job activity monitor, I can't see anything.
Can we see the running jobs from job activity monitor in standard edition or not?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

ramana3327 (1/5/2016)
Hi,
We are using standard edition.
When I execute a job manually and try to see the job running status from job activity monitor, I can't see anything.
Can we see the running jobs from job activity monitor in standard edition or not?

Yes. I did it in SQL 2008 SE this afternoon. I'm not sure where to go with this, so here's a couple ideas:

Are you running the job itself?

When you look at the activity monitor, did you refresh it?

Is the job still running by the time you refresh the job activity monitor?

Does the execution show in the job history?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Hi,

I do not think the feature is edition dependent. So you should fiind it. Go through the below MSDN link for more details.

Now there is always a possibility that the job runs a very short period of time and thats the reason you can't see the job status/progress in monitor!

Did you check the job history?

https://msdn.microsoft.com/en-us/library/ms188272(v=sql.100).aspx

Thanks.

ramana3327 SSCoach Points: 19722 More actions · Answer 3

I started job manually it is showing like running but from job activity monitor not able to see the job and even from sysjobactivity

So I again click on start step then I can see the job ia running from jobactivitymonitor

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

ramana3327 (1/5/2016)
I started job manually it is showing like running but from job activity monitor not able to see the job and even from sysjobactivity
So I again click on start step then I can see the job ia running from jobactivitymonitor

When you look at the activity monitor, did you click the refresh button to refresh the list?

Is the job still running by the time you refresh the job activity monitor?

Does the execution show in the job history?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions