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
LVL 5
25112Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MarcjevConnect With a Mentor Commented:
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
 
SharathData EngineerCommented:
Can you explain what exactly you are looking for?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.