Best way to schedule a package to run during the day

Hi,

What is the best way to schedule a package to run every 30 minutes during the day. Would it be using SQL Agent Jobs? If so, what is the things I need to consider.

Thank you,

Aldo

Hi ya,

Yes it would be Sql Server Agent job. You would need to make the package and then deploy it to either Sql Server or File system. You will get errors if the Agent credentials running agent service is different then your package credentials. If that is the case search for either Sql Agent proxy or SSIS jobs not running in Sql Server agent and you will find loads of posts.

The rest is pretty easy. You would create a new job in agent and then for daily frequency put it as 30 minutes.

Hope this helps

Cheers

Rizwan

|||Thanks you!