Is it possible to run SQL-Cursor through cmd??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Question123
    New Member
    • Feb 2008
    • 41

    Is it possible to run SQL-Cursor through cmd??

    Hi
    Is it possible to run SQL-Cursor through command prompt??
    if yes how?? plz help me.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    What are you trying to do?

    -- CK

    Comment

    • Question123
      New Member
      • Feb 2008
      • 41

      #3
      Originally posted by ck9663
      What are you trying to do?

      -- CK
      i want to run cursor through schedular.

      Comment

      • ck9663
        Recognized Expert Specialist
        • Jun 2007
        • 2878

        #4
        Create it in stored proc.

        Use OSQL to execute it.

        -- CK

        Comment

        • Delerna
          Recognized Expert Top Contributor
          • Jan 2008
          • 1134

          #5
          OR
          create in a stored proc
          create a DTS to run it
          create and schedule a job in "management/SQL Server Agent/Jobs"
          (The context menu of the DTS has an option to schedule the DTS)

          ALSO
          vb scripts can be scheduled
          vbscripts can also execute stored procs on SQL Server

          :)

          Comment

          Working...