Post reply

schedule job

  • May 15, 2008 at 5:00 am

    #182438

    Hi!

    I want to schedule a job and I want it to run in the last week of every month, every 7 days. The solution I created was to make 7 different schedules for the last days of every month. For example, "last monday of every 1 month". So far so good, but the problem is that 6 of them are enabled but the sunday scheduled isn't. I've tried to enabled it but with no success. Is there other way to do this type of schedule or, in my solution, is some sort of clash?

    Thanks.

  • May 15, 2008 at 5:57 am

    #815777

    What error is it giving you?

  • May 15, 2008 at 2:20 pm

    #816132

    One solution would be to schedule the job to run every day. In the first step write some t-sql code with some date functions that makes the step succeed and goto step 2 (the one that does the work) if it succeeds and make it quit with success if step 1 fails. If you like this idea but are unsure about the t-sql code let me know with a better explanation of what days you want your step to run and I can write some code for you.

    Regards

  • May 16, 2008 at 5:16 am

    #816359

    thanks for the help!

    I've solutioned the problem.

    Thanks once again.

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

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