• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Jobs

 
Arjun Shastry
Ranch Hand
Posts: 1898
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
How to get the list of SQL jobs which are present on a database Server using JDBC?
Thanks

 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic