How to detect SQL errors in scheduled jobs?

This page on scheduling exports says, 

"Although the script examples can be used as a base for designing your own reports, the scripts lack proper error handling/logging and should be improved to handle this."

I thought if I passed -stoponerror or -stoponsqlwarning to dbviscmd, I would get a nonzero error code and could print stderr to see what went wrong with my query. That's not how it works. Do I have to read the logs every time to be sure my SQL ran OK?

For anyone who wants to see, here's the gist of the Python I'm using to export:

command = ['cmd', '/c', 'dbviscmd.bat', '-connection', connection,
		   '-stoponerror','-stoponsqlwarning', '-sqlfile', str(sqlfilepath)]

with subprocess.Popen(command, stdout=logfile, stderr=PIPE,
					  cwd=r"C:\Program Files\DbVisualizer") as p:
	err = p.stderr.read().decode('utf-8')
	if err:
		print("Error while running the following external command. Exiting.")
		print()
		print(p.args)
		print()
		print(err, file=sys.stderr)
		sys.exit() 

Thanks for the reply. For some reason I couldn't find this thread by searching the forum for Fireslinger, even with Google site:support.dbvis.com. Is there a way to see all of my threads?

Your reassurance helped me dig deeper into my problem: I was launching dbviscmd with cmd /k, so that always returned 0. My new handle_error looks like this:

def handle_err(process: 'result from subprocess.Popen)'):
    out, err = process.communicate()
    print()
    if process.returncode:
        print(f"Error: process returned error code {process.returncode}. Check program log and then quit.",
              file=sys.stderr)
        return process.returncode
    elif err:
            print("Error while running the following external command. Exiting.")
            print()
            print(process.args)
            print()
            print(err, file=sys.stderr)
            sys.exit()

I meant to add that I did, of course, go to my profile and use the feature that shows you all of your own articles and tickets. None of the tabs showed this one.