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).
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
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
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.
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.
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
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.
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
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
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
加载中,请稍侯......