We have ETL Jobs which runs in SQL Server so every day the job rans scheduled but i wanted to view the job status based on step wise whether my job is passed/failed through QTP-Vb Script.Did any one tried this before to give me some inputs.
It would be slower in execution, but you can execute Queries from QTP/UFT and should be able to do what you require as logged steps in a test easily.
You would have the benefit of the historical logs being maintained in QC/ALM if you do as well.
I have set-up plenty of queries from QTP but not completed the Transform/Load steps.
While I have been working for Businesses that are Vendor partners with HP, IBM and Microsoft, my opinions and advice is my own.
The solutions provided are either sourced from my own scripting libraries or from a quick Google Search.