sql-server-agent

相关标签：javascript jquery android 多少钱 iPhone

SQL Server Agent 2005 job runs but no output

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn\'t complete properly (no error messages though).[详细]

2022-12-28 03:54 分类：问答
SQL Job: CmdExec with Multiple Arguments

Is it possible to specify two arguments to CmdExec in SQL JOb Step? I have MyApp.exe Para1 Para2 but it only recognize par开发者_JAVA百科a1.You can check in sysjobsteps to see what SQL Server stores[详细]

2022-12-26 06:08 分类：问答
Powershell Transcript is empty when running script from SQL Agent Job in 2005 SQL Server

I have a complex Powershell script that gets run as part of a SQL 2005 Server Agent Job. The script works fine, but it uses the \"Start-Transcript $strLogfile -Append\" command to log all of it\'s act[详细]

2022-12-21 19:55 分类：问答
How to implement SQL Server Job that waits to another job finish?

I\'m looking a way to implement a precedence step on SQL Server Agent that will verify is a specific job is running. If so, the step will entry in a \"wait\" state until first job finish with success.[详细]

2022-12-18 12:22 分类：问答
Get date of last successful job run?

I have a single step job that executes a stored procedure. I would like get the date of the last successful job execution time so that I can just update a delta instead of the whole set of data.[详细]

2022-12-17 22:24 分类：问答
SQL Job: How to start with?

Can anyone help me to create an SQL job in SQL ser开发者_JAVA技巧ver Agent (SQL 2008) ,which will run in a purticular time interval(Ex: Daily) and select records from a table with status=1 (select nam[详细]

2022-12-17 01:02 分类：问答
Can only connect to SQL Sever 2008 Express remotely afer server restart

I am running SQL Server 2008 Express and can connect to it fine using port forwarding through my router, AND when I am on the same subnet.[详细]

2022-12-11 06:15 分类：问答
SQL Agent not kicking off an SSIS package

I have a server that has a SQL Agent j开发者_运维问答ob setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management[详细]

2022-12-10 23:30 分类：问答
SQL Agent Job - Connection may not be configured correctly or you may not have the right permissions on this connection?

I\'m getting this error when running an SSIS package through SQL Agent Failed to acquire connection \"ORACLE ADO.NET\". Connection may not be configured correctly or you may not have the right permiss[详细]

2022-12-10 05:24 分类：问答
Using an SQL Agent Job to call procedures in a loop

I am putting together a job on SQL Enterprise Manager 2000 to copy and delete records in a couple database tables. We\'ve run a straight up mass copy and delete stored procedure, but it could be runni[详细]

2022-12-08 21:50 分类：问答