Post reply

Sql server Job - type Operating System(CmdExec)

  • June 10, 2014 at 7:51 am

    #308983

    Hi,

    I have a sql server job which is of of type Operating System(CmdExec)

    and following is the command I see under command part of the job properties. I need to change this job to add more recipients to the current email recipient list.

    C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /DTS "\File System\Inventoryreport\NewInventoryReport" /SERVER Rserv1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

    In the above command I was able to navigate until the path C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe but not able to navigate to the part /DTS "\File System\Inventoryreport\NewInventoryReport.

    I am expecting that there will be a folder inventoryreport and then there will be a file NewIneventoryReport but not able to find this path.

    Any ideas?

    Thanks.

  • June 10, 2014 at 9:29 am

    #1720462

    I usually put the path to the .dtsx package after a /FILE. My guess is you should be looking in your integration services catalogs under your instance in SSMS, not under the file system. I am not sure as I don't use the catalogs in my environment.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply