It sounds like your MSSQLSERVER service is not running or something. On our server there is a SQL server service manager in the sys tray. Check if that is running. Otherwise I would just make sure Monarch Data Pump 8 Service and MSSQLSERVER Services are turned on. If they are not on than it is understandable there is no activity on the SQL database.
It sounds like a permissions issue.
First thing to check would be the ability to write to ProcessQueue.xml.
To find the location of this, check this registry key:
You may want to check that this file is being updated when you submit a job via the web service. Or you could just check that the web user account has write access.
You could create a different folder and change the registry entry to point to that if you are worried about access to windows emp for security reasons, but you will have to restart the Data Pump service.
Both start process and startprocessusingmanifest when invoked return a tracking ID but the job never gets registered and processed. I ran SQL profiler and there's no DB activity on the DWCHServer when either method is invoked.
I get no error messages either.
However calling through the .net API the same 2 methods work just fine.
I've done the uninstall reinstall dance a couple of times now with no change in behavior.
Any idea how to troubleshoot this? Logs or something maybe? /b[/quote]