Page 1 of 1
How to get job-id of a job?
Posted: Wed Feb 16, 2005 5:17 am
by vinodlakshmanan
How can I get the ID of a job using dsjob or Administrator? I'm using the foll query in administrator
Code: Select all
SELECT * FROM DS_JOBS WHERE ??=MyJob
Firstly, what will ?? be? And is the syntax correct, do I need to enclose the Job Name in double-quotes. Also, what is the difference between
Code: Select all
SELECT * FROM DS_JOBS
LIST DS_JOBS
Posted: Wed Feb 16, 2005 5:36 am
by Sainath.Srinivasan
SELECT * FROM DS_JOBS -> SQL Syntax
LIST DS_JOBS -> Universe Syntax
Answer for ?? -> NAME
Single Quotes
Re: How to get job-id of a job?
Posted: Wed Feb 16, 2005 9:59 am
by vcannadevula
vinodlakshmanan wrote:How can I get the ID of a job using dsjob or Administrator? I'm using the foll query in administrator
Code: Select all
SELECT * FROM DS_JOBS WHERE ??=MyJob
Firstly, what will ?? be? And is the syntax correct, do I need to enclose the Job Name in double-quotes. Also, what is the difference between
Code: Select all
SELECT * FROM DS_JOBS
LIST DS_JOBS
select * from DS_JOBS where NAME = 'ur Job Name'