Doing repetitive queries in SQL

I’ve taken all the SQL classes here but I’ve seen nothing about how to handle multiple daily repetitive queries. I’ve got a friend that has used dbase for decades and he runs daily programs querying multiple databases for his bosses. He just types in “do x or do y” and away it goes and it’s all done in seconds and he has a pdf file to email to the muckety mucks. Is there a way to program queries in SQL like this or would I have to jump over to dbase or some other language?