SQL Server 代理计划 - 半小时 [英] SQL Server Agent Schedule - hourly on the half

查看:23
本文介绍了SQL Server 代理计划 - 半小时的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我创建了一个 SSIS 包以连接到外部提供程序并通过 FTP 下载一些数据.他们告诉我他们的进程每小时创建一次数据,每小时一次,但是我想在半小时执行一次我的包,因为我想确保他们的进程在我连接之前完成.

I've created an SSIS package to connect to an external provider and download some data over FTP. They tell me their process creates the data once an hour, on the hour, however I would like to execute my package every hour on the half because I want to ensure their process is finished before I connect.

如您所见,我创建了一个每日计划,从 00:30 开始每小时运行一次.这是我想要它做什么所需的全部还是我遗漏了什么?

As you can see, I've created a daily schedule which runs hourly starting at 00:30. Is this all that is required for what I want it to do or am I missing something?

谢谢

推荐答案

这就是我想要它做的事情所需要的全部吗?

Is this all that is required for what I want it to do?

是的!

这篇关于SQL Server 代理计划 - 半小时的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆