How Do I Launch DTS Jobs/OS Commands From Within Navision...

Comments

• ara3n Member Posts: 9,258

  2006-11-19

  Hello. You have to connect through ado and execute the following command
  MaintenancePlan is a job.
  
  

  EXEC msdb..sp_start_job 'MaintenancePlan'
  

  
  
  Here is an example on how to use ADO.
  
  http://www.mibuso.com/forum/viewtopic.php?t=2401&highlight=ado+connect

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0
• Fisherman Member Posts: 456

  2006-11-19

  I've never used SHELL in Navision, but if the code will run on the server, then you should be able to use SHELL to call DTSRun - a command line exe that runs DTS packages. If you will be running the code from a client other than the SQL Server, then you'll need to use ADO.

  0
• bougeac Member Posts: 24

  2006-11-20

  Hi guys, thanks for the help, will look at both approaches...
  
  cheers,
  
  chris

  0