1
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • How do you set a SQL Server job step status?

    I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch 'step' (Step 3) to check if the file has been sent (see...

    Redwine20 pointsBadges:
  • SQL 2008 job problem

    I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The job script follows: EXEC...

    DavidHa!!110 pointsBadges:
  • Microsoft SQL Server BCP Utility password

    I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the 'in' argument, a format file and an error file.  I have 'hard coded' the user name and password in the command line using the 'U' and 'P' arguments. I am looking for a method...

    Redwine20 pointsBadges:
  • SQL Server 2005 Express

    Hi, Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation? I know it is probably a good idea to atleast change the autogrowth setting from 1MB but...

    Db23290 pointsBadges:
  • SQL DTS package scheduling

    When a DTS package is scheduled to run at a specific time of day, is it done through the use of a stored procedure or a job?

    Gic5 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following