Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not...


SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running

Author
Message
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
Hi,

SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher'

is generally used to check whether SQL Server is running. This works fine for all other servers except two servers... In these two servers there is no column having Program_Name as SQL Server Agent but the Agent is running fine... Any ideas why it is not listed?

But once SQL Server Agent is re-started, then I'm able to see the program name 'SQLAgent - Generic Refresher' in sysprocesses... Any thoughts are welcome...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858
From BOL about sysprocesses:

Contains information about processes that are running on an instance of Microsoft SQL Server


So if it ain't running it shouldn't be there



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
Hi Jack,
Buy my case is SQL Server Agent is running but the entry is not there in sysprocesses...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858
Sakthivel Chidambaram (12/17/2008)


But once SQL Server Agent is started, then I'm able to see the program name 'SQLAgent - Generic Refresher' in sysprocesses... Any thoughts are welcome...


Based on this you say when it is started you can see it.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
oh.... that was a big type error... I have edited my post... Thanks for that...
Actually I was trying to say that after restarting SQL Server now it is visible in sysprocesses....

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Vladan
Vladan
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1810 Visits: 750
Hello Sakhti,
Did you restart SQL Server, or SQL Server Agent?
Maybe the problem is that you are confusing two things - one is whether SQL Server as such is running, another one is whether SQL Server Agent is running. Server can be running, while Agent is stopped - maybe that was the reason the entry was missing?

PS. Maybe you should remove the bold from your signature, this way it looks that your main question is whether we are using Google w00t



Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
Hi,
Let me put it this way...

Server Name : SQL001
Instance Name: SQLSRV
Running since: 15 days

Now I connect to the server using Management Studio and run below query
"SELECT * FROM sysprocesses WHERE Program_Name like '%Agent%Refresher'

It does'nt return any output, but when I go to Services.msc, I'm able to see that SQLSERVERAGENT is running in this instance but not getting listed in above query.

Now I Restart the SQLSERVERAGENT of this instance and run the same query I get result...

What has gone wrong? How though SQL Server Agent is running it is not listed in sysprocesses?

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Steve Rodgers
Steve Rodgers
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 240
Sakthi,

I have the same problem as you describe. Did you ever get a resolution to the problem?

Regards,
Steve.
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
Nope... Sad

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Todd Reddinger
Todd Reddinger
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1086 Visits: 349
Not sure if this could be the problem.

If I run this query I do not get a result:
select * from master.sys.sysprocesses
WHERE Program_Name like '%Agent%Refresher'

But if I run this query i do get a result:
select * from master.sys.sysprocesses
WHERE Program_Name like '%Agent%Refresher%'

The "%" on the end seems to make a difference.


Thanks,

ToddR
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search