SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: C# to SQL JOB

  1. #1
    SitePoint Member
    Join Date
    Nov 2008
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    C# to SQL JOB

    Hellow, I have nasty code in C# and I want to run it from SQL JOB.
    I don't know how to do that, can please someone help me ?

    My code in C#:

    string ExePath = @"C:\Program Files\CRESetup\CRE.exe";
    string ExportPath = ConfigurationSettings.AppSettings["FileRoot"] + ConfigurationSettings.AppSettings["TempFilePath"];
    string WebPath = "/" + ConfigurationSettings.AppSettings["TempFilePath"] + "/crexport/";
    string RptPath = ConfigurationSettings.AppSettings["FileRoot"] + @"bin\crexport_export.rpt";

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,627
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Build a command line project and run a sql job to execute the executable you made. Not that the code you have does much aside from set some variables.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •