| Shell script with SQL query [message #147037] |
Tue, 15 November 2005 08:10 |
abcklm
Messages: 8
Registered: November 2005
|
Junior Member |
|
|
I have to write shell script, which will be kicked off daily at 5 PM.That shell script runs sql plus which runs the SQL quey in production instance using userid/password. After querying the result has to be stored in shared drive X://Apps/USERS_LIST/20051114. (20051115 means todays date 2005-11-15. Using of TODAY'S DATE in outputfile will make that file unique). Ultimate goal is to get active users list every day at 10 PM.Here the sql query is
SELECT USER_NAME
FROM FND_USER
WHERE END_DATE IS NOT NULL
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
