更新时间:2023-02-03 08:11:45
在用于导出数据的向导屏幕上,选择保存SSIS包选项,下一个屏幕将为您提供保存该包的选项。然后转到SQL Server代理并安排该软件包
右键单击作业并选择新作业
向作业提供名称和说明 >
>
选择步骤,命名步骤,选择SSIS作为类型,选择包来源,然后选择您的包
计划作业
Experts !!
I am not familiar with SQL Server Management Studio and never had to schedule tasks on an SQL Server.
I am exporting my database to MS Access everyday. I need Management Studio to do this automatically everyday at 2:00 am.
Any ideas.
On the wizard screen that you are using to export data, select the Save SSIS Package option, the next screen will give you the options to save that package. Then go to SQL Server Agent and schedule that package
Right click on Jobs and select New Job
Give the Job a name and description
Select Steps, Name the step, select SSIS as the Type, select the Package source and then select your Package
Schedule the job