question

jacobmat9 avatar image
jacobmat9 asked

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)
scheduling
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
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.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Agree. Instead of creating a new job, create a new schedule in the existing SQL Agent job and that should do the trick.
0 Likes 0 ·
jacobmat9 avatar image jacobmat9 commented ·
Thank you very much..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.