Scheduler

[brucebruce]

I have a question about UFT. I currently run UFT scripts off of an excel sheet with a driver. I was wondering if there is a way to schedule (date and/or time) when each of those tests run and insert that into my excel?

Currently my driver runs the following:

testFile                                Sheet                          Execute
TestSheet.xlsx                    SampleSheetName  N 
TestSheet.xlsx                    BrowserLaunch         N
TestSheet.xlsx                    Database                    Y

Where each test script is listed in their own sheet in an Excel file called SampleExcelSheet.xlsx. I basically want to add a feature where I can run each test at a specific date. Perhaps add a new column called Date of execution?

[ADITI1992]

Hi BruceBruce,

have u tried this with window scheduler. create a vbs file and schedule it with windows scheduler to run.
Read:https://www.learnqtp.com/how-to-run-qtp-scripts-at-scheduled-time/

I hope it helps..

Thanks,
Aditi..

[brucebruce]

Thank you for that. The scheduler does work and I will try that. I have another question. I want to run the scheduler to launch a main script which imports a datasheet. Is there a way to run that same main script and have it import a diffrent datasheet depending on the day with the scheduler?

[supputuri]

Your VBS file should have the following.
- Launching QTP
- Opening your Main Script

you should do the above using AOM (automation object model).