Redwood explorer V7 cronacle - job monitoring

[Former Member]

Hi All,

Tool Used : Redwood explorer V7 sp5

I have a similar issue where i need to check job status ( running, completed , erred etc) of several jobs daily which eats a lot of my time. I was thinking is there a way to , lets say , i need to check 10 jobs ,can i  run a query by giving job names and i can get the details ( starttime, endtime, status etc) , if possible i would then export this output to my email so that every time i don't have to check every job again n again.

PS: i tried google for this stuff , not really helpful.

Looking forward for your expertise advise on this, any pointers will be helpful.

Thanks,

Ashish Sharma

[nanda_kumar21]

You can start from creating a query filter in your job monitor.

Then use that filter to create a report and run system_reportrun jobdefinition to get a CSV output.

thanks

Nanda

[Former Member]

Hi Ashish,

Use mail type job definition for this, and in Action->precondition develop a redwood script to and pass the out to Parameter and same output can be used in HTML source code.

you can use the below query to get active jobs or you can give job names if needed.

select Job.* from Job where Job.Status IN ('R','W') order by Job.ScheduledStartTime desc

Regards,

Ravindranath Reddy

;