scheduling a different time for a job which is already running
I have 4 tables which is scheduled to run from 9:00pm to 3:00am. (SQL server 2008R2) The question is without creating a NEW ETL, can i create a new job for the same 4 tables to run at 3:00pm daily. I don't see any overlap. (The job which is running move these 4 tables from one DB to another DB)
Not sure I understand. You have an ETL-package (SSIS I presume), scheduled to run in an agent job at certain intervals between 9pm and 3am. If you want the same job to run at 3pm, you can create another schedule for the job and have that run daily at 3pm.