I have a SQL Server 2008 SSIS job which executes some Win 32 exe files. This job runs fine when i execute the job through BIDS (On Windows 2008 box). Now i have deployed the package in MSDB database a
How can I create job in SQL Server 2008 Standard Edition?开发者_C百科 I cannot find the menu for the command.The command in SQL Server Management Studio to create a new SQL Agent job is under the SQL
I have a parent package that simply calls 4 child packages. All of these (parent and child) packages have been saved with package passwords. However only 2 of these child packages have non-sql connect
A looooong time ago, we\'re talking 8 years now, I prototyped a proof of concept of using a web site as an alternative to a Windows service or SQL Server Agent by retaining an application pool\'s upti
This question already has answers here: Closed 11 years ago. Possible Duplicate: SQL Server Agent Job 开发者_运维知识库Timeout
I have a vb script which moves files from one server to another and it works successfully when run manually but when a job is created in SQL Agent to automate the process it doesn\'t perform the task.
I\'m trying to run a SQL Agent Job with a step that is a SSIS File, and I need this step to be run as administrator.
I\'m trying to find a way to have the SQL Server \'SQL Agent\' run a particular piece of 开发者_JS百科code on job step events. I had hoped that there was a way using SMO to register a callback method
Task: Write timestamps into MS SQL database table every second. Solutions: External application which writes timesta开发者_StackOverflow中文版mps by schedule (Sql agent for example).
I have a pretty basic SSIS package that is attempting to read a file hosted on a share, and import its contents to a database table.The package runs fine when I run it manually within SSIS.However, wh