• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 40
  • Last Modified:

tSQL to find background running [administrative tasks] processes currently

is there a query to pinpoint any or all of the below if they are running:

administrative tasks:
https://technet.microsoft.com/en-us/library/ms189315(v=sql.105).aspx
0
25112
Asked:
25112
1 Solution
 
SharathData EngineerCommented:
Can you explain what exactly you are looking for?
0
 
MarcjevCommented:
Use

select * from sys.dm_exec_requests and look for the command column

most of the tasks have their own command like 'backup database','backup log' etc. the help of db_exec_request gives more info
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now