如何根据用户定义的开始日期和结束日期安排SQL作业 [英] How to schedule sql job as per user defined start date and end date
问题描述
嗨
我已经创建了一份工作,并在每天上午11:00安排工作。
我也从用户那里获取参数,即开始日期,结束日期,天数:星期一,星期三,结婚...
但不知道如何根据用户输入日期和日期动态安排。
示例:
开始日期:2015- 12-23 00:00:00.000,
结束日期:2015-12-28 00:00:00.000,
天数:周五,周日
仅在周五,周日定义的开始日期和结束日期之间安排工作。
谢谢..
-Aniket Mali
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
推荐答案
以下系统sp可以:
Hi, The below system sp can do:
exec sp_add_jobschedule @job_name = @job,
@name = 'MySchedule',
@freq_type=1,
@active_start_date = @startdate,
@active_start_time = @starttime
另请参阅链接:https://www.mssqltips.com/sqlservertip/3052/simple-way -to-create-a-sql-server-job-using-tsql / [ ^ ]
这篇关于如何根据用户定义的开始日期和结束日期安排SQL作业的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!