如何安排作业以每天运行 SQL 查询? [英] How can I schedule a job to run a SQL query daily?

问题描述

我需要知道如何使用 SQL Server 代理作业每天运行 SQL 查询，并且需要最少的配置设置.

I need to know how to make a SQL query run daily using a SQL Server Agent job, with minimum required configuration settings.

推荐答案

1. 展开 SQL Server Agent 节点并右键单击 SQL Server Agent 中的 Jobs 节点并选择 'New Job'

在 'New Job' 窗口中，在 'General' 选项卡上输入作业名称和描述.

In the 'New Job' window enter the name of the job and a description on the 'General' tab.

选择窗口左侧的'Steps'，然后点击底部的'New'.

Select 'Steps' on the left hand side of the window and click 'New' at the bottom.

在 'Steps' 窗口中输入步骤名称并选择要运行查询的数据库.

In the 'Steps' window enter a step name and select the database you want the query to run against.

将要运行的 T-SQL 命令粘贴到命令窗口中，然后单击 'OK'.

Paste in the T-SQL command you want to run into the Command window and click 'OK'.

点击新作业"窗口左侧的'Schedule'菜单并输入日程信息(例如每天和某个时间).

Click on the 'Schedule' menu on the left of the New Job window and enter the schedule information (e.g. daily and a time).

点击'OK' - 应该就是这样了.

Click 'OK' - and that should be it.

(您当然可以添加其他选项 - 但我想说这是您设置和安排工作所需的最低限度)

(There are of course other options you can add - but I would say that is the bare minimum you need to get a job set up and scheduled)

这篇关于如何安排作业以每天运行 SQL 查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！