one more help ... what if i want the sysouts of the faileds jobs in email ...

yes i want jobs which are of particular names somthing like %abc% and also for the present odate....

query to find failed jobs in active network ?

this myt help u in the query...

to_char(to_timestamp(trim(timestmp)
, 'YYYYMMDDHH24MISS') - numtodsinterval(elaptime / 100
, 'SECOND'), 'YYYY-MM-DD HH24:MI:SS') as start_time
, to_char(to_date(trim(timestmp), 'YYYYMMDDHH24MISS')
, 'YYYY-MM-DD HH24:MI:SS') as end_time

hello,

I am not sure about OSQL , but i would suggest that u can mention in the step tab that when it finds any exception then it fails.


somethin like
On stmt = * code = exception*
Do NOTOK

you can use a query something like this

delete jobname from cmr_ajf where holdflag like'Y';

Hello Mani,

I am not aware of how we use "DEF_DO_MAIL"
Could you please explain me as to how i use it .
is it a table i can run a select query on ( i dont think so )
.
Your explanation would be appreciated.

query to find the status of Agents ??

You can use the table cmr_ajf ( if the jobs are in active network )

u can use a query like

select jobname,startrun from cmr_ajf where start run between '01/17/2014 14:00:00' and '01/17/2014 17:00:00';

hi ,
I want to extract all the SAP jobname with the OWNER name .
could anyone please help with that .. ITS URGENT...

Vamsi ,

Post proc would only throw an alert to the alert server. how would it send an email ?

How to send email when the job is running longer??

Thanks Sandeep and Vassi ... I looked into it and got what i required... Actually I need another help . I am creating calendars for 2014 and i have 100s of calendars for 2013 when i copy them and create new 2014 i see that copy is date dependent and moves the calendars days by 1 day fwd as (next yea...

I want to change the start date of the week in the scheduling tab in calendar..
could you please let me know how this can be done .
i see a * on monday which represent the start day of the week need to change it to sunday as the start day

you can install Netcool for this