This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates 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?