You can test that the stored procedures have been successfully installed using a web call URL. This test checks that the database has the correct stored procedures installed and that they are working correctly.
For staging system:
To run the test, type the following URL into your bowser:
http://HOST_MACHINE/SERVERURL/VTLJobManagementRESTService.svc/JSON/TestStagingStoredProcedures
The test results will show any exceptions that occur while trying to run the staging area stored procedures.
This staging stored procedures test can be run at any time after installation.
For target system:
To run the test, type the following URL into your browser:
http://HOST_MACHINE/SERVERURL/VTLTargetSystemRESTAdapter.svc/JSON/TestTargetSystemStoredProcedures
The test results will show any exceptions that occur while trying to run the target system stored procedures.
This target system stored procedures test can be run at any time after installation.