每月自动执行一次StoreProcedure [英] Automatically Execute StoreProcedure once in Every Month

问题描述

我想要一个月份执行一次的程序，就像我们获得移动账单一样。所有细节都将保持相同，只有计算部分，日期，月份将被更改。所有以前的账单明细也在数据库中

I want a procedure which will execute once in month same as we are getting mobile bill.All detail will remain same only calculation part,date,month will get changed.and all previous bill detail is also there in database

推荐答案

您需要使用SQL Server代理创建可根据您的要求安排的作业。



如何：安排作业（SQL Server Management Studio） [ ^ ]

You need to use SQL Server Agent for creating the job which you can schedule as per your requirement.

How to: Schedule a Job (SQL Server Management Studio)[^]

您可以在SQL2008中创建数据库作业并指定您的SP /包来处理和配置它何时运行等。

启动Management Studio然后使用Object资源管理器转到

SQLNode>> Sql Server代理>>工作

右键单击它并选择新工作



此链接mig ht help

msdn.microsoft.com/en-us/library/ms190268(v = sql.100）.aspx

You can create Database job in SQL2008 and assign your SP/Package to process and configure it when to run etc.
Start Management Studio then using Object explorer Go to
SQLNode>>Sql Server Agent>>Job
Right click it and select New Job

This link might help
msdn.microsoft.com/en-us/library/ms190268(v=sql.100).aspx

这篇关于每月自动执行一次StoreProcedure的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！