.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Maintenace Plan not executing properly from command line.

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
I am running SQL 2005 Standard SP3 on Microsoft Windows NT 5.2 (3790) This is a two node active/active cluster. I had a maintenance plan that was called from the command line by a third party scheduler (Tidal) and everything ran fine.  Then a new copy of the maintenance plan was created with additional code and named with _new at the end.  The new plan ran fine interactively (right click and execute).  The old plan was renamed to _old and the new plan renamed to remove the _new.  The scheduler will no longer run the maintenance plan.  I have attempted to run the plan manually from the command line, as the scheduler would do.  It finds the plan, says its starting and then runs for 6 seconds (should be about 50 minutes) and says it completed successfully, but obviously did not.  The history of the plan does not show any execution.  I have tried exporting the plan, dropping it and reimportng (jiggling the handle), I have also exported he old plan and dropped it, thinking there might be some internal name glitch.  I have no idea what is going on, but need to get the plan to run from the command line--forgetting the scheduler for the moment, the manual run from the command line does not work.  (I'll worry about the scheduler later).  The command that is being run is: dtexec /SQL “Maintenance Plans\ProvDUpeCln_CKN

View Complete Post

More Related Resource Links

Executing Command Logic in a View Model

Through the use of the Windows Presentation Foundation's (WPF) advanced data-binding capabilities, the logical structure of a user interface can relatively easily be disconnected from its presentation. Bindable components can now contain nearly all of an application's user interface logic and in most circumstances, replace the need for controller objects from the classic Model-View-Controller (MVC) pattern. So it's no wonder that a new pattern for UI design has appeared

OLE DB Command in DFT is executing sp_execute for each row?

HI All, The larger issue i am tackling is how to identify/update changed FACT table rows from incoming rows. I have gone through a lot of samples, Project REAL examples etc...the conclusion i came to was to use a Lookup transform and use the OLE DB Command task to issue updates. Is this the right way to go? Now specifically, when i do that, the DFT is taking an extremely long time to run through 250k rows. When i ran Profiler, i am seeing that the OLE DB Command is issuing an sp_execute for each row! I would like to hear what i am doing wrong with my overall approach and specifically for this OLE DB Command? Thanks!

sql command line

i have a problm about mysql command line;it is desapeared at once when i enter the password to my sql command line how is that happening?

Solution deployment requires executing execadmsvcjobs command on search server to complete deploymen

We have multiple Sharepoint 2007 farms and deploy custom code weekly to the farms. On one o the farms it is required to run stsadm -o execadmsvcjobs on the Search server in the farm in order for solution deployments to complete deploying. These are solution recycles that we are running. This is the only farm this happens on and all farms are identical. In central admin it shows the solution state as deploying. Farm Config Sharepoint 2007 SP2 w Dec Cumulative updates 1 WFE 1 Search server 1 SQL server

Specify Instance Port Number on Command Line Install

Is there a way to specify which port we want our named SQL Express instance to run on during a command line install with no interaction from the user?  If not, is there a way we can change the dynamic port selected after the install without any user interaction?Nick's Programming Tips


Platform:   2 servers (clustered) with windows server 2008 x64 r2 (enterprise) Application: sql2008 x64 enterprise with SP1 (slip streamed) Problem: sql2008 new cluster install fails using the COMMAND LINE with a CONFIGURATIONFILE.INI The install starts but stops with the log file in the setup bootstrap folder  => (Detail_ComponentUpdate.txt) below. Bottom lines indicate a REBOOT is required; did a reboot on both nodes and still have the same problem. Used the following command line to launch sql2008 setup: Setup.exe /Q /SQLSVCPASSWORD="**********" /AGTSVCPASSWORD="**********" /ASSVCPASSWORD="**********" /ISSVCPASSWORD="**********" /RSSVCPASSWORD="**********" /ConfigurationFile=ConfigurationFile.ini Anyone has any success installing sql2008 using command line and command file? thanks john ------------------------------- tail end of the Detail_ComponentUpdate.txt file ----------------------------------------------- 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59:44 Slp: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x64.exe exit code: 0 2010-09-01 15:59:44 Slp: Launching external tool: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x86.exe 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59

Error on install : The INSTANCESHAREDWOWDIR command line value was not specified.

Hi,I'm trying to upgrade my dev pc for SQL Server 2008. I've removed all previous installations of sql server 2005, then installed Business Intelligence Studio & Management Tools.During setup (when selecting features), I received the following error : "The INSTANCESHAREDWOWDIR command line value was not specified. This value must be specified when the INSTANCESHAREDDIR value is specified."I plan to install sql server 2008 on another drive (D:\Microsoft Sql Server\).I'll try to set manually parameters (D:\Microsoft Sql Server\...) in the command-line arguments. FailAny hint from the team ?

How do I obfuscate .Net IL code using command line program?

How do I obfuscate .Net IL code using command line program? I want free tool that can be deployed to obfuscate DLL generated from compiled tool?

mantenace plan is not properly working

hi, maintenance plan is not working it skip 20% database backup , not showin error id

How to know when a process run through the command line is finished - C#

Hi , I'm developing a web application in asp.net using  C# and running a .bat file from the command line. The .bat file runs another 3rd party software which resides in the server.Need to know whether the 3rd party software ran successfully to the end.Here is the code I used to run .bat file through the command line.bool RunBat(){            bool success= false;          try{            System.Diagnostics.Process proc = new System.Diagnostics.Process();           proc.StartInfo.WorkingDirectory = @"E:\test";                      proc .StartInfo.FileName = "ABC.bat";                               proc .Start();                     proc .Close();               success= true;          }       

Command line publish

HiI am new to DOT NET web publishing (not to software development).  We need through command line to build our site (which we already do using msbuild.exe), but the resulting files are way too many and it takes our to ftp it to the server.I am able to publish the website and reduce its size by ~90%; however, we need to do this through command line not manually using the GUI.I have read many postings but noone is clear on how to do it (and msbuild seems to no be able to do this). Can anyone provide me a link.Thank youPS. We are using Visual Studio 2010 and DOT NET4.0

.Net 1.1 Command Line Compile

Hello. I need to use Notepad to make changes to an old .Net 1.1 app. I then would like to use the command line compiler. Can someone tell me the syntax (and where I need to navigate to in my cmd) to compile the changes I make in the code behind pages into the DLL?Thanks in advance!

Driving install of standard web install project from command-line

I have a VS project (web service) for which I created a standard VS Web Setup project.  That project creates the typical setup.exe and project.msi files.  When run interactively, the setup prompts the user to select an IIS Site, a Virtual directory and the Application Pool.  I'd like to drive this setup silently from a script, passing the necessary args on the command-line such that the user isn't prompted.  I've played some with the args in an attempt to set those three prompts using properties, but without luck. Can anyone tell me if there are public properies on the MSI that would allow me to set those prompts via the command-line?    

ReportBuilder 2.0: open server report via command line?

Hello,is it possible to launch ReportBuilder 2.0 and pass the server report to open via command line?Searching the forums I have found this blog-entry (Launching Report Builder from the command line), but I think it is for ReportBuilder 1.0, because SQL Server 2005 is mentioned. I have tried it anyway, but ReportBuilder 2.0 just starts with an empty report.If I specify a rdl-file from the local file system the report will open fine:MSReportBuilder.exe d:\temp\samplereport.rdlthanks in advance and best regards,Gerald

Report Builder 2.0 command line

Hiare there any command line switched for the new report builder?I like to export a report directly (say, in a pdf file) without further user interaction.Any clues?RegardsKlaus

SSIS Project Build - Command Line

We are trying to automate our Build and Deployment process for SSIS Packages. Can some one suggest me the way to perform the build and deployment using Command Line.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend