November 19, 2012 at 12:57 am
As the question. It is used in an SQLAgent job. Googling links it to SSIS execution, but no explanation AFAI can find. Link with Data Collector, which tells me something, but not about this executable.
Any link to an overview on this exe? Something about which parameters can be used? How and why you would use it?
TIA,
Greetz,
Hans Brouwer
November 19, 2012 at 1:30 am
i guess you are looking for this
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 2:29 am
Tnx for answering, I don't know if this is what I am looking for. I can find a relation in BOL between Data Collection and this dcexec utility
I have this command string in a job step on a SQL2008R2 box:
dcexec -c -s 2 -i "MSSQLSERVER" -m 0 -e $(ESCAPE_NONE(STOPEVENT))
This is one of several, with slightly different commands, but all starting with dcexec.
It runs as a CMD command, so possibly I should not look for it in the SQL Server suite at all. BOL does not mention it as a stand-alone utility.
Greetz,
Hans Brouwer
November 19, 2012 at 3:47 am
DCEXEC is used for the Management Data Warehouse as a part of the collector sets that actually grabs performance metrics and pumps it to a management data warehouse for reporting.
Unfortunately I have not been able to find any documentation on the utility anywhere. I fear that it is only available internally at MS.
Joie Andrew
"Since 1982"
November 28, 2012 at 7:57 am
Dont panic, if you have, or your dba has setup a data collection warehouse these are the jobs that get setup automatically. You can confirm this by going into SSMS ->Management -->Data Collection-->System Data Collection Sets. Under this you should find 3 Tasks..Disk Usage, Query Statistics and Server Activity. There may be other because your dba is on the ball. Hope this helps.
November 29, 2012 at 3:33 am
Tnx for answering and tnx for the heads-up, John. It makes things clearer indeed.
Greetz,
Hans Brouwer
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply