Needed Script for Gather Schema Stats [message #561238] |
Thu, 19 July 2012 11:49 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi all
i have told to Create a script that monitors the status of Gather Schema Statistics. If GSS is not scheduled send an alert.
Its in Oracle E-business Suite R12
please let me know how i can proceed with this
Cheers
|
|
|
Re: Needed Script for Gather Schema Stats [message #561318 is a reply to message #561238] |
Fri, 20 July 2012 08:11 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
see right now GSS ran on 19th July at 19:00 and now it is already been scheduled on 26th July 12 at 19:00
i can see this from front end but how could i get the it done from select query and get the output that next GSS is scheduled on 26th July
|
|
|