How to schedule sql job as per user defined start date and end date

Question

0.00/5 (No votes)

See more:

Hey Hi,

I have created a job and schedule it on daily basis on 11:00AM.

I have taken parameters also from user i.e Start date, End Date, Days: mon,tus,wed...

but don't know how to schedule dynamically as per user input dates and days.

Example:
Start Date: 2015-12-23 00:00:00.000,
End Date: 2015-12-28 00:00:00.000,
Days : Friday,Sunday

Schedule Job only on Friday,Sunday between defined Start Date and End Date.

Thank you..

-Aniket Mali

Posted 21-Dec-15 19:21pm

Aniket Mali

Updated 21-Dec-15 19:22pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

willington.d · Accepted Answer · 2015-12-21T20:18:00

Hi, The below system sp can do:

SQL

exec sp_add_jobschedule @job_name = @job,
@name = 'MySchedule',
@freq_type=1,
@active_start_date = @startdate,
@active_start_time = @starttime

Also refer to the link: https://www.mssqltips.com/sqlservertip/3052/simple-way-to-create-a-sql-server-job-using-tsql/[^]

How to schedule sql job as per user defined start date and end date

1 solution

Solution 1

Add your solution here

Preview 0

How to schedule sql job as per user defined start date and end date

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us