i have procedure "proc_daily_end " that we executed daily at night to generate bills and contains multiple procs in it. due to huge data it takes time and irretaes us. there is procedure that we used to reconfigure indexes this is taking too much of time.
Now my boss command me to run the re-configure index program by sql server job. the "proc_daily_end" proc will execute the job that contains the reconfigure index proc and execute in the way that "proc_daily_end" will not wait for reconfigure index proc.
Kindly suggest me the best practices in doing this and considerations.