Post reply

How to create custom schedule for sql server agent job

  • December 1, 2008 at 2:18 am

    #127295

    Hi everybody,

    this is my first post and I searched for a soluten but unfortunately couldn't find one.

    I'm in the process of developing an ssis package that exports data into some text files that will be consumed by an other application. Creating the package and running it seems to be no problem.

    I also managed to let the package being run by sql server agent on a schedule.

    My problem is that the package (creating the files with the exported data) must run every month on the 3rd work day. This 3rd work day also depends on the holidays in that specific month. There is nothing as a work day I can select in sql server creating a schedule for a job.

    Has anybody an idea how I can creata a custom schedule in sql server? Do I have to write an application that calls my package or sql agent job?

    Thanks in adavence.

    Armin

  • December 1, 2008 at 9:24 am

    #905704

    You can implement this with a script task. The script task can be run at the end of your package execution and it will use the SQL Job Agent API to setup next job execution day/time. Check this script for ideas how to manage the SQL Job Agent with the API.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 2, 2008 at 6:10 am

    #906165

    Hi!

    Thanks for your reply. I will give it a try.

    I tried by directly modifying the entries in [msdb].[dbo].[sysjobschedules] but that didn't bring the expected results.

    Armin

  • August 5, 2012 at 12:45 am

    #1521736

    See if this helps

    http://sqlactions.com/2012/08/05/how-to-create-custom-schedule-for-sql-server-agent-job/[/url]

    Prashant
    Check out my blog at http://sqlactions.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply