This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Arjun, That information is usually stored in the data dictionary, so you simply need to query the data dictionary.
Of-course, data dictionaries are not standard across different DBMS's, nor across different versions of the same DBMS, so if you want a more detailed answer, you need to provide a more detailed question -- like what is your definition of a "SQL job" and what DBMS are you using?