Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

tSQL to find background running [administrative tasks] processes currently

Posted on 2016-08-10
2
Medium Priority
?
39 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
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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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 article I will describe the Copy Database Wizard 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.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

972 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