November 10, 2015 at 2:01 pm
Hi all experts,
I'm trying to schedule a job using SQL JOB AGENT
The logic- the SSIS package should run on every
Monday :12pm-10pm..(should run every 30 mins)
Tuesday 8am-9pm..(should run every 30 mins)
Wen:8am-1pm..(should run every 30 mins)
Is this possible if I using sql job agent?? or
Should I need add additional script task to my SSIS package?
P.S After schedule this package is there anyway to implement this package can not fail during these time .For eg. if someone forgot to close the excel file then package will be failed and give us an error at this time I want to send an email say "file is open" Or in the package property if we don't change 64bits as false the package will give us an error and I want to send an email say" please change propertise". Is there anyway to control these together?
Thanks
austin
November 10, 2015 at 2:13 pm
caojunhe24 (11/10/2015)
Hi all experts,I'm trying to schedule a job using SQL JOB AGENT
The logic- the SSIS package should run on every
Monday :12pm-10pm..(should run every 30 mins)
Tuesday 8am-9pm..(should run every 30 mins)
Wen:8am-1pm..(should run every 30 mins)
Is this possible if I using sql job agent?? or
Should I need add additional script task to my SSIS package?
P.S After schedule this package is there anyway to implement this package can not fail during these time .For eg. if someone forgot to close the excel file then package will be failed and give us an error at this time I want to send an email say "file is open" Or in the package property if we don't change 64bits as false the package will give us an error and I want to send an email say" please change propertise". Is there anyway to control these together?
Thanks
austin
It's possible. Create one job with 3 schedules, one for each day.
The logic to deal with potential errors and sending out emails should be part of the package, not the job.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 10, 2015 at 2:36 pm
Thank you Alvin.
Create one job with 3 schedules, one for each day -Complete
For error handling I know it's regarding SSIS package not sql job agent.
I appreciate If you can provide the detail code/script for this situation.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply