Interested to Buy Any Domain ? << Click Here >> for more details...
I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?
- 1 Answers
- 25 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What do you understand by anchoring in reports?
What are the types of windows (window style)?
Difference between lexical and bind varible.
How will you run ms_batch file in forms?
What is confine mode and flex mode?
Any work done in oracle workflow builder. Did you customize or build a new workflow?
What is the format trigger?
How to get / select the nth row from the table?
Difference between bind parameter and lexical parameter.
Explain the different types of queries created in reports?
What are summary column and placeholder column in reports?
What is the page protect in reports?
Oracle General 
