August 21, 2008 at 10:57 am
Hi,
I m having a problem with scheduling a job with windows task scheduler. Actually I have 2 SSIS packages. I want to schedule those 2 packages in such a way like 1 package executes only first 4 days of the month and the other package executes rest of the month. I should use only task scheduler for performance issue....may be this is very small issue...But I m not getting any ideas how to schedule this...
Thanks in advance..
August 21, 2008 at 10:58 am
Is there a real reason not to use SQL Server Agent? It's going to be a lot easier to set up, monitor, maintain, etc., in there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 21, 2008 at 11:03 am
I don't find any reason...but my boss is wants only through task scheduler....
August 21, 2008 at 11:22 am
GSquared is right, SQL Agent is the best way. Sometimes bosses need a little education in these matters...
If that doesn't work 🙂 you can create a DOS batch file or SQL Server script to do some date checking and determine which SSIS package to execute.
You could also throw in date check logic into your SSIS package (if today is NOT in the first 4 days then do all of this stuff, else exit). Put in an override variable just in case you need a special run of it.
OR you could create 2 jobs and have the first job "execute on the 1st" click on advanced and have it repeat every 24 hours for the next 72 hours. The second job gets uglier... you'd have to create multiple schedules - one for each day of the month (because not every month has 31 days).
Hope one of those could work for you,
Rob
August 21, 2008 at 11:26 am
Thanks Rob...may be I ll go for date checking in my SSIS package...it should work...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply