You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.
How would you create these jobs?
A.
Create both jobs by using events raised by the scheduler
B.
Create both jobs by using events raised by the application
C.
Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D.
Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
The file arrives on the system –(1)-> Bulk load operations –(2)-> Rebuild indexes.
So we can configure a job to start when the file watcher detects the presence of the file (1) and the application triggers the Scheduler (2).
So why not C.
I don’t understand