如何在作业完成时更新本地表格中的值 [英] how to Update Value in local tabel when job Finished

问题描述

SQL Server 2008，我需要在执行服务的所有任务完成执行作业后立即将一些值更新到数据库中。换句话说，我想做一些像工作完成时状态直接改变这个状态的东西。我认为做存储过程就像：Update（表名）Set（Field）= 1），但我不知道如何存储作业完成时执行的程序

SQL Server 2008 , I need to update some values into Database as soon as all the tasks of Executing Service have finished executing there jobs. In other words, I want do something like status when the job finished directly change this status .i think that doing stored procedure like: Update (Table Name ) Set ( Field ) = 1 ) ,but i don't Know how make the stored procedure executed when the job finished

推荐答案

在执行完所有执行任务的任务完成后，你可以调用存储过程来通过它来更新某些值在表中。这将是执行服务的最后一步。

Right after all the tasks of executing service have finished executing there jobs, you can call the stored procedure through which you can update some value in the table. This will be the very last step of the executing service.

这篇关于如何在作业完成时更新本地表格中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！