sql-agent_开发者

Executing SSIS Package as SQLAgent Job

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[详细]

2023-04-13 04:26 分类：问答

How can i create SQL Agent job in SQL Server 2008 standard?

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[详细]

2023-04-02 14:41 分类：问答

SSIS parent doesn't need password but child packages do - how do I get this to run in SQL server Agent?

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[详细]

2023-04-02 07:12 分类：问答

ASP.NET web self-maintainer as alternative to Windows service or SQL Agent

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[详细]

2023-03-29 17:41 分类：问答

Schedule job on SQL Server Agent to stop [duplicate]

This question already has answers here: Closed 11 years ago. Possible Duplicate: SQL Server Agent Job 开发者_运维知识库Timeout[详细]

2023-03-26 14:27 分类：问答

SQL Agent and Running SSIS Across Network Not Working

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.[详细]

2023-03-14 14:29 分类：问答

SQL Agent Run SSIS package as Administrator

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.[详细]

2023-02-24 19:42 分类：问答

Get SQL Agent job status without polling?

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[详细]

2023-01-24 18:36 分类：问答

Implementation of periodic writing timestamps in ms sql database

Task: Write timestamps into MS SQL database table every second. Solutions: External application which writes timesta开发者_StackOverflow中文版mps by schedule (Sql agent for example).[详细]

2023-01-05 05:51 分类：问答

SSIS DTS Package flat file error - "The file name specified in the connection was not valid"

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[详细]

2022-12-28 19:07 分类：问答