Solved

tSQL to find background running [administrative tasks] processes currently

Posted on 2016-08-10
2
36 Views
Last Modified: 2016-08-22
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
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 41

Expert Comment

by:Sharath
ID: 41750865
Can you explain what exactly you are looking for?
0
 
LVL 10

Accepted Solution

by:
Marcjev earned 500 total points
ID: 41758287
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question