blocks|key|3156835|text|SQL+Server+Express+doesn't+include+SQL+Server+Agent，因此不可能只创建SQL+Agent作业。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3156836|您可以做的是：|3156837|您可以通过创建批处理文件和SQL脚本文件，并通过Windows任务调度器运行它们来“手动”创建作业。|3156838|例如，您可以使用以下两个文件备份数据库：|3156839|backup.bat:|style|BOLD|3156840|sqlcmd+-i+backup.sql|code-block|syntax|javascript|3156841|backup.sql:|3156842|backup+database+TeamCity+to+disk+=+'c:\backups\MyBackup.bak'|3156843|只需将这两个文件放在同一个文件夹中，并通过Windows任务计划程序执行批处理文件。|3156844|第一个文件是一个Windows批处理文件，它调用sqlcmd+utility并传递一个SQL脚本文件。|3156845|SQL脚本文件包含T-SQL。在我的示例中，只有一行代码用于备份数据库，但是您可以在其中放入任何T-SQL。例如，您可以改为执行一些UPDATE查询。|CODE|3156846|3156847|如果您要创建的作业是用于备份、索引维护或完整性检查，您也可以使用Ola+Hallengren提供的出色的Maintenance+Solution。|3156848|它由一系列存储过程(以及SQL+Server非Express版的SQL+Agent作业)组成，在FAQ中有一个关于如何在SQL+Server+Express上运行作业的部分：|3156849|3156850|如何开始使用SQL+Server+Express上的SQL+Server维护解决方案？|blockquote|3156851|3156852|SQL+Server+Express没有SQL+Server代理。因此，必须使用cmd文件和Windows计划任务安排存储过程的执行。请按照以下步骤操作。|3156853|SQL+Server+Express没有SQL+Server代理。因此，必须使用cmd文件和Windows计划任务安排存储过程的执行。请按照以下步骤操作。|3156854|3156855|下载MaintenanceSolution.sql.的|3156856|ordered-list-item|3156857|3156858|3156859|执行MaintenanceSolution.sql。此脚本创建所需的存储过程。|3156860|3156861|3156862|创建cmd文件以执行存储过程；例如：|3156863|3156864|-E+-S+.\SQLEXPRESS+.\SQLEXPRESS+-d+-Q+"EXECUTE+dbo.DatabaseBackup+@Databases+=+'USER_DATABASES'，@Directory+=+N'C:\Backup'，@Backup+FULL=+'FULL'“-b+-o+sqlcmd|3156865|3156866|在Windows计划任务中，创建调用cmd文件的任务。|3156867|3156868|3156869|计划任务。|3156870|3156871|3156872|启动任务并验证它们是否正在完成successfully.|3156873|3156874|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL_Server_Express#Capabilities|1|http://msdn.microsoft.com/en-us/library/ms162773.aspx|2|https://ola.hallengren.com/|3|https://ola.hallengren.com/frequently-asked-questions.html^0|J|W|0|0|0|0|0|0|B|0|0|0|B|0|0|0|O|E|1|0|1U|6|0|0|1G|K|2|0|1C|3|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|2N|8|@]|9|@$A|2O|B|2P|1|2Q]]|C|$]]|$1|D|3|E|5|6|7|2R|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|2S|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|2T|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|2U|8|@$A|2V|B|2W|L|M]]|9|@]|C|$]]|$1|N|3|O|5|P|7|2X|8|@]|9|@]|C|$Q|R]]|$1|S|3|T|5|6|7|2Y|8|@$A|2Z|B|30|L|M]]|9|@]|C|$]]|$1|U|3|V|5|P|7|31|8|@]|9|@]|C|$Q|R]]|$1|W|3|X|5|6|7|32|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|6|7|33|8|@]|9|@$A|34|B|35|1|36]]|C|$]]|$1|10|3|11|5|6|7|37|8|@$A|38|B|39|L|12]]|9|@]|C|$]]|$1|13|3|-4|5|6|7|3A|8|@]|9|@]|C|$]]|$1|14|3|15|5|6|7|3B|8|@]|9|@$A|3C|B|3D|1|3E]]|C|$]]|$1|16|3|17|5|6|7|3F|8|@]|9|@$A|3G|B|3H|1|3I]]|C|$]]|$1|18|3|-4|5|6|7|3J|8|@]|9|@]|C|$]]|$1|19|3|1A|5|1B|7|3K|8|@]|9|@]|C|$]]|$1|1C|3|-4|5|6|7|3L|8|@]|9|@]|C|$]]|$1|1D|3|1E|5|6|7|3M|8|@]|9|@]|C|$]]|$1|1F|3|1G|5|6|7|3N|8|@]|9|@]|C|$]]|$1|1H|3|-4|5|6|7|3O|8|@]|9|@]|C|$]]|$1|1I|3|1J|5|6|7|3P|8|@]|9|@]|C|$]]|$1|1K|3|-4|5|1L|7|3Q|8|@]|9|@]|C|$]]|$1|1M|3|-4|5|6|7|3R|8|@]|9|@]|C|$]]|$1|1N|3|-4|5|6|7|3S|8|@]|9|@]|C|$]]|$1|1O|3|1P|5|1L|7|3T|8|@]|9|@]|C|$]]|$1|1Q|3|-4|5|6|7|3U|8|@]|9|@]|C|$]]|$1|1R|3|-4|5|6|7|3V|8|@]|9|@]|C|$]]|$1|1S|3|1T|5|1L|7|3W|8|@]|9|@]|C|$]]|$1|1U|3|-4|5|6|7|3X|8|@]|9|@]|C|$]]|$1|1V|3|1W|5|6|7|3Y|8|@]|9|@]|C|$]]|$1|1X|3|-4|5|6|7|3Z|8|@]|9|@]|C|$]]|$1|1Y|3|1Z|5|1L|7|40|8|@]|9|@]|C|$]]|$1|20|3|-4|5|6|7|41|8|@]|9|@]|C|$]]|$1|21|3|-4|5|6|7|42|8|@]|9|@]|C|$]]|$1|22|3|23|5|1L|7|43|8|@]|9|@]|C|$]]|$1|24|3|-4|5|6|7|44|8|@]|9|@]|C|$]]|$1|25|3|-4|5|6|7|45|8|@]|9|@]|C|$]]|$1|26|3|27|5|1L|7|46|8|@]|9|@]|C|$]]|$1|28|3|-4|5|6|7|47|8|@]|9|@]|C|$]]|$1|29|3|-4|5|6|7|48|8|@]|9|@]|C|$]]]|2A|$2B|$5|2C|2D|2E|C|$2F|2G]]|2H|$5|2C|2D|2E|C|$2F|2I]]|2J|$5|2C|2D|2E|C|$2F|2K]]|2L|$5|2C|2D|2E|C|$2F|2M]]]]

SQL Server Express <a href="http://en.wikipedia.org/wiki/SQL_Server_Express#Capabilities" rel="noreferrer">doesn't include SQL Server Agent</a>, so it's not possible to just create SQL Agent jobs.
What you can do is: 
You can create jobs &quot;manually&quot; by creating batch files and SQL script files, and running them via Windows Task Scheduler. 
For example, you can backup your database with two files like this:
backup.bat:
<pre><code>sqlcmd -i backup.sql
</code></pre>
backup.sql:
<pre><code>backup database TeamCity to disk = 'c:\backups\MyBackup.bak'
</code></pre>
Just put both files into the same folder and exeute the batch file via Windows Task Scheduler.
The first file is just a Windows batch file which calls the <a href="http://msdn.microsoft.com/en-us/library/ms162773.aspx" rel="noreferrer">sqlcmd utility</a> and passes a SQL script file. 
The SQL script file contains T-SQL. In my example, it's just one line to backup a database, but you can put any T-SQL inside. For example, you could do some <code>UPDATE</code> queries instead.
<hr />
If the jobs you want to create are for backups, index maintenance or integrity checks, you could also use the excellent <a href="https://ola.hallengren.com/" rel="noreferrer">Maintenance Solution</a> by Ola Hallengren.
It consists of a bunch of stored procedures (and SQL Agent jobs for non-Express editions of SQL Server), and in the <a href="https://ola.hallengren.com/frequently-asked-questions.html" rel="noreferrer">FAQ</a> there’s a section about how to run the jobs on SQL Server Express:
<blockquote>
<h1>How do I get started with the SQL Server Maintenance Solution on SQL Server Express?</h1>
SQL Server Express has no SQL Server Agent. Therefore, the execution of the stored procedures must be scheduled by using cmd files and Windows Scheduled Tasks. Follow these steps.
SQL Server Express has no SQL Server Agent. Therefore, the execution
of the stored procedures must be scheduled by using cmd files and
Windows Scheduled Tasks. Follow these steps.
<ol>
<li>Download MaintenanceSolution.sql.
</li>
<li>Execute MaintenanceSolution.sql. This script creates the stored procedures that you need.
</li>
<li>Create cmd files to execute the stored procedures; for example: 
sqlcmd -E -S .\SQLEXPRESS -d master -Q &quot;EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory =
N'C:\Backup', @BackupType = 'FULL'&quot; -b -o C:\Log\DatabaseBackup.txt
</li>
<li>In Windows Scheduled Tasks, create tasks to call the cmd files.
</li>
<li>Schedule the tasks.
</li>
<li>Start the tasks and verify that they are completing successfully.
</li>
</ol>
</blockquote>

blocks|key|258650|text|SQL+Server+Express版本在某些方面受到限制-其中一个方面是它们没有允许您计划作业的SQL代理。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|258651|有几个第三方扩展提供了这种功能-请查看以下内容：|258652|258653|Express+Agent+for+SQL+Server+Express:+Jobs,+Jobs,+Jobs+and+Mail+(最新更新是2005年的更新，不是anymore).|unordered-list-item|offset|length|258654|SQL+Scheduler|258655|维护的|258656|entityMap|0|LINK|mutability|MUTABLE|url|https://weblogs.asp.net/alex_papadimoulis/Express-Agent-for-SQL-Server-Express_3A00_-Jobs_2C00_-Jobs_2C00_-Jobs_2C00_-and-Mail|1|http://www.lazycoding.com/products.aspx^0|0|0|0|0|1R|0|0|0|D|1|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|10|8|@]|9|@$H|11|I|12|1|13]]|A|$]]|$1|J|3|K|5|G|7|14|8|@]|9|@$H|15|I|16|1|17]]|A|$]]|$1|L|3|M|5|6|7|18|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|Q|R|S|A|$T|W]]]]

SQL Server Express editions are limited in some ways - one way is that they don't have the SQL Agent that allows you to schedule jobs.

There are a few third-party extensions that provide that capability - check out e.g.:

<ul>
<li><a href="https://weblogs.asp.net/alex_papadimoulis/Express-Agent-for-SQL-Server-Express_3A00_-Jobs_2C00_-Jobs_2C00_-Jobs_2C00_-and-Mail" rel="nofollow noreferrer">Express Agent for SQL Server Express: Jobs, Jobs, Jobs and Mail</a> (latest update is from 2005, it isn't maintained anymore).</li>
<li><a href="http://www.lazycoding.com/products.aspx" rel="nofollow noreferrer">SQL Scheduler</a></li>
</ul>

blocks|key|259612|text|创建SQL代理作业的功能在SQL+Server+Express+Edition中不可用。另一种方法是执行批处理文件，该批处理文件使用Windows任务计划程序执行SQL脚本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|259613|为此，首先创建一个名为sqljob.bat的批处理文件|offset|length|style|BOLD|259614|sqlcmd+-S+servername+-U+username+-P+password+-i+<path+of+sqljob.sql>|code-block|syntax|javascript|259615|将servername、username、password和path替换为您的。|CODE|259616|然后创建名为sqljob.sql的SQL脚本文件。|259617|USE+[databasename]
--T-SQL+commands+go+here
GO|259618|将[databasename]替换为您的数据库名称。在编写SQL脚本时，USE和GO是必需的。|259619|sqlcmd是一个用于执行SQL脚本的命令行实用程序。创建这两个文件后，使用Windows任务计划程序执行批处理文件。|259620|NB:之前对这个问题发布了几乎相同的答案。但我觉得它并不完整，因为它没有指定使用sqlcmd的登录信息。|259621|entityMap^0|0|B|A|0|0|1|A|C|8|L|8|U|4|0|6|A|0|0|1|E|10|3|14|2|0|0|6|0|0|3|14|6|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|15|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|16|8|@$D|17|E|18|F|O]|$D|19|E|1A|F|O]|$D|1B|E|1C|F|O]|$D|1D|E|1E|F|O]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1F|8|@$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|R|3|S|5|J|7|1I|8|@]|9|@]|A|$K|L]]|$1|T|3|U|5|6|7|1J|8|@$D|1K|E|1L|F|O]|$D|1M|E|1N|F|O]|$D|1O|E|1P|F|O]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1Q|8|@$D|1R|E|1S|F|O]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1T|8|@$D|1U|E|1V|F|G]|$D|1W|E|1X|F|O]]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]]|10|$]]

The functionality of creating SQL Agent Jobs is not available in SQL Server Express Edition. An alternative is to execute a batch file that executes a SQL script using Windows Task Scheduler.

In order to do this first create a batch file named sqljob.bat

<pre><code>sqlcmd -S servername -U username -P password -i &lt;path of sqljob.sql&gt;
</code></pre>

Replace the <code>servername</code>, <code>username</code>, <code>password</code> and <code>path</code> with yours.

Then create the SQL Script file named sqljob.sql

<pre><code>USE [databasename]
--T-SQL commands go here
GO
</code></pre>

Replace the <code>[databasename]</code> with your database name. The <code>USE</code> and <code>GO</code> is necessary when you write the SQL script.

<code>sqlcmd</code> is a command-line utility to execute SQL scripts. After creating these two files execute the batch file using Windows Task Scheduler. 

NB: An almost same answer was posted for this question before. But I felt it was incomplete as it didn't specify about login information using <code>sqlcmd</code>.

Could anyone please explain to me how to create jobs in <code>SQL Server Express</code> edition?

How to create jobs in SQL Server Express edition

备份数据库

SQL Server

数据库

Windows

谁能给我解释一下如何在SQL Server Express版中创造就业机会？

问如何在SQL Server Express edition中创建作业
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server Express edition中创建作业EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server Express edition中创建作业
EN