|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:05 PM
Points: 271,
Visits: 852
|
|
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..
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, July 01, 2009 12:21 PM
Points: 6,281,
Visits: 3,254
|
|
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.
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:05 PM
Points: 271,
Visits: 852
|
|
| I don't find any reason...but my boss is wants only through task scheduler....
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Wednesday, June 10, 2009 4:17 PM
Points: 12,
Visits: 54
|
|
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
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:05 PM
Points: 271,
Visits: 852
|
|
| Thanks Rob...may be I ll go for date checking in my SSIS package...it should work...
|
|
|
|
