How to get job-id of a job?

[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

[Sainath.Srinivasan]

SELECT * FROM DS_JOBS -> SQL Syntax
LIST DS_JOBS -> Universe Syntax

Answer for ?? -> NAME

Single Quotes

[vcannadevula]

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'