Page 1 of 1
Audit DS jobs
Posted: Wed Feb 08, 2006 12:01 pm
by shrey3a
Hi,
For Audit purpose I need to know the jobs changed for todays date.
I'm running the command
SELECT DTM, MODFIFIER FROM DS_AUDITS
0r
SELECT * FROM DS_AUDITS
or
SELECT MODIFIER, DTM
FROM UNNEST DS_AUDIT ON MODS
but it gives me name of all the jobs been modified I need to add the where clause for todays date and I'm not sure of the syntax.
-Thanks
Munish
Posted: Wed Feb 08, 2006 12:13 pm
by ArndW
The syntax is SQL, but there was a
thread here earlier today which will answer your question.
Posted: Wed Feb 08, 2006 1:57 pm
by shrey3a
Hi ,
IS there is any DS component in DS_AUDIT for mod date as I want to select all the jobs modifief for today only like
SELECT MODIFIER, DTM FROM DS_AUDIT WHERE DS_JOBS.MODIFIED_ON >= 2004-10-04 00:00:00
the above SQL do not work for where clause.
Thanks
- Munish
Posted: Wed Feb 08, 2006 2:17 pm
by vcannadevula
shrey3a wrote:Hi ,
IS there is any DS component in DS_AUDIT for mod date as I want to select all the jobs modifief for today only like
SELECT MODIFIER, DTM FROM DS_AUDIT WHERE DS_JOBS.MODIFIED_ON >= 2004-10-04 00:00:00
the above SQL do not work for where clause.
Thanks
- Munish
Try this
SELECT * FROM DS_AUDIT WHERE DTM > '2006-01-14 00:00:00'
Posted: Wed Feb 08, 2006 7:18 pm
by kduke
Code: Select all
SELECT * FROM DS_AUDIT WHERE DTM > EVAL "OCONV(@DATE-1, 'D/MDY[2,2,4]')"
Posted: Wed Feb 08, 2006 11:20 pm
by ray.wurlod
I thought the column name was DTM, not MODIFIED_ON. There is no SQL - anywhere - that allows you to query successfully with made-up column names.
Posted: Thu Feb 09, 2006 12:25 am
by kcshankar
Hi Minish,
For Audit purpose I need to know the jobs changed for todays date.
I'm running the command
use CLASS ='2' to get
only the status of the jobs.
Code: Select all
SELECT * FROM DS_AUDIT WHERE DTM > '2006-02-01 00:00:00' AND CLASS = '2'
regards
kcs