This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell 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?