Im new to toad data point. I have built a automation script that imports the contents of a spreadsheet into an Oracle table. It actually works fine. I have it set to send me an email if an error occurs. However, when I removed the spreadsheet from its location and ran the script again it did not send an error email. Upon looking at the log it says:
Start: “xyz spreadsheet” does not exist
Attempted to import 0 rows
Successfully imported 0 rows
Done: “xyz spreadsheet” does not exist
Could anybody let me know what I can do to have this error out and send me an email if the spreadsheet isnt there?