调度SQL Server 2008q [英] Scheduling sql server 2008q

问题描述

你好，

我在sql server 2008和asp.net 3.5中创建了一个预订软件，我想创建一个调度程序，在该调度程序中，结束日期后应将订阅程序包取消激活，并在结束日期后禁用该程序包的所有功能.让我知道要在数据库级别和编码级别中编写什么代码，以及在sql server上设置调度程序的步骤.l
寻求满意的答复.

谢谢

Hello,

I,am creating a subscription software ins sql server 2008 and asp.net 3.5, i want to create a scheduler in which after end date the subscription package should be shwn as deactivated and all functions to that package will get disabled after end date.Do let me know what code is to be written in both database level and coding level, and steps to setup the scheduler on sql server.l
Looking for a favourable response.

Thanks

推荐答案

参考-创建和附加计划求职 [^ ] .

您必须检查结束日期是否已过.如果通过，则更新表中的某些Boolean列，例如"IsActivated".将其更新为0，这意味着它将被停用.

Refer - Create and Attach Schedules to Jobs[^].

You have to check if end date is passed or not. If passed, then update some Boolean column in table something like "IsActivated". Updated this to 0, that means it would be deactivated.

这篇关于调度SQL Server 2008q的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！