Post reply

Welcome SQL Agent job experts

  • November 10, 2015 at 2:01 pm

    #309562

    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

    #1838980

    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.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    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

    #1838984

    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