import pymysql.cursors

conn = pymysql.connect(
    host='localhost',
    db='test_db',
    user='root',
    password='toor',
    charset='utf8',
    # get dict
    cursorclass=pymysql.cursors.DictCursor
)

sql = 'SELECT * FROM jobs'

cur = conn.cursor()
cur.execute(sql)
jobs = cur.fetchall()

cur.close()
conn.close()

for job in jobs:
    print(job)