Solved

tSQL to find background running [administrative tasks] processes currently

Posted on 2016-08-10
2
28 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 40

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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