I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?
Answer Posted / Vivek Chandel
To schedule a report to run at specific times but exclude Sundays, you can use Oracle's DBMS_SCHEDULER package to create a job that runs the report and set the start date/time accordingly. Additionally, you can set the JOB_IS_NON_DEAFULT attribute in the job definition to TRUE and add a condition to the schedule based on day of the week (not Sunday).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many concurrent programs you have customized, can you name some of them?
Any work done in oracle workflow builder. Did you customize or build a new workflow?
Have you used lexical parameters in reports?
Are you familiar with user exits in reports?
Were you involved in any data conversion, which one?