Post reply

SQL Server Job Schedule

  • January 30, 2014 at 7:17 am

    #285067

    Hi,

    I need to schedule a job to run on 1,5,8,12,18,24,26,30 of each month at the same time 11 PM. Is there a way to schedule everything in one schedule other than having a schedule for each day with frequency set to monthly.

    Thanks.

  • January 30, 2014 at 7:50 am

    #1684682

    You can not do it with one schedule.

    A work around for that may depend on what is your job scheduled to execute: t-sql, ssis package, ...?

    Igor Micev,My blog: www.igormicev.com

  • January 30, 2014 at 1:52 pm

    #1684845

    The job executed a stored procedure with no parameters.

    Thanks.

  • January 31, 2014 at 2:00 am

    #1684952

    Than it should be simple.

    You can schedule your job on daily basis, and in the code for calling the SP you can use a little code

    if day(getdate()) in (1,5,8,12,18,24,26,30)

    print 'executing sp...'

    -- exec sp_example

    else

    print ' executing nothing...'

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com

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

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