We are looking to Develop a script (Macro) to notify of BCA scheduled jobs that are about to expire.
Macro should run once per day and notify the expiration date of the scheduled jobs before 1month, 1week, 1day to the Aministrator by mail.
Okay, the DS_PENDING_JOB table will likely hold the information that you are interested in. You can tie this in with the email code posted here. You are only interested in jobs that are sat with a status of Waiting, I guess.
Thanks for your reply.
I have code to send emails from BCA.
I need to capture the expiration date and time of the scheduled jobs.
Expiration date and time are storing in encrypted code in DS_PENDING_JOB table.
How to capture/convert into sysdate format.
You can search this site, which has topics, including a fairly recent one which discusses the storage of dates in the repository. Basically its the number of seconds since a date in 1970. There is a simple formula which converts these dates. Alternatively, you can look on the BO cd at the repository section, which provides a similar explaination.