Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 213310

For questions about the SQL Server monitoring stored procedure written by Adam Machanic

2 votes
3 answers
5k views

Get actual Job Name from Program Name column of the results while running sp_whoisactive or ...

I am running sp_whoisactive on my Prod and offload the data for analysis. When I run sp_whoisactive or sp_who2 and if there is any SQL Agent Jobs running it would always display the Program Name like …
Albert's user avatar
  • 47
0 votes
0 answers
501 views

Get actual Job Name of the running SSIS package from Program Name column of the results whil...

When I run sp_whoisactive or sp_who2 and if there is a SSIS Package running it would always display in the Program Name as the name of the running SSIS Package like SSIS-Package-{063BC46B-1F74-4207-A2 …
Albert's user avatar
  • 47