如何在主机中运行我的sqlserver作业？ [英] how run my sqlserver job in host?

问题描述

我的机器上有ms sqlserver数据库，我创建作业并通过db

配置sendmails但是当我把作业脚本运行在数据库主机上时它没有运行而且我可以'' t在主机上配置sendmails，如何运行我的作业脚本并配置sendmail ???

i have ms sqlserver database on my machine and i create job and configure sendmails by db
but when i take job script to run on database host it didn''t run and i can''t make configuration of sendmails on host ,how can i run my job script and configure sendmail???

推荐答案

请按照链接：

sp_start_job（Transact-SQL） [ ^ ]

http://www.mssqltips.com/sqlservertip/1730/different-ways-to-execute-a -sql-agent-job / [ ^ ]

http://www.interworks.com/blogs/bbickell/2010/01/15/how-execute-and-monitor-agent-job -using-t-sql-sql-server-20052008 [ ^ ]

http://sqlusa.com/bestpractices2005/startjobfromstoredproc/ [ ^ ]

Please, follow the links:
sp_start_job (Transact-SQL)[^]
http://www.mssqltips.com/sqlservertip/1730/different-ways-to-execute-a-sql-agent-job/[^]
http://www.interworks.com/blogs/bbickell/2010/01/15/how-execute-and-monitor-agent-job-using-t-sql-sql-server-20052008[^]
http://sqlusa.com/bestpractices2005/startjobfromstoredproc/[^]

这篇关于如何在主机中运行我的sqlserver作业？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！