Sql Server 2000 creates a scheduled job to run a stored procedure

Have a client that is using sql server 2000. I know tsql. I need to create a scheduled job that runs a script to create a report from and/or insert data into a seperate table. How do i setup a job to run a sql script? Can anyone point me to a guide on creating reports from these jobs. Thanks. Do i need to create dts packages?

Open SQL Server Enterprise Manager. Expand the Management node. Right Click Job from the Sub Nodes and Select New Job from the context Menu.

You can use THIS to create the jobs.

SQL Server 2000 Creating a Linked Server to SQL Server 2008

In SQL Server 2000, I'm trying to create a linked server to SQL Server 2008. Everything I've tried raises errors of one flavor or another. In SQL Server 2000 Enterprise Manager, I: Right-click Linked Servers under the server's Security node, then cho

SQL Server 2000 (creating all dates with a date range)

I was wondering if there is a way in SQL Server 2000 to create all dates given a start and end date as a result. I know I can achieve this with T-SQL looping. I am looking for a non looping solution. Also in 2005 you can use the recursive with clause

How to create a scheduled job that runs every minute in the apex sales force

I am planning to create a scheduled job using scheduled apex in salesforce. I know that we can write and run the job for every one hour. I would like to know if there is a way we can run the code for every minute instead of every one hour. I know the

Search for Modularity in SQL Server 2005 - Return multiple sets of records to a stored procedure

I've had this problem a few times and solved it the same way. But it's not pretty and I was wondering if anyone knew of anything a bit more elegant... The Basic Aim: - I have a piece of code that is common through-out many Stored Procedures. - For ma

SQL Server: Set the value of the variable using the stored procedure (from one to another)

I have a stored procedure where I am taking all the input parameter values and then within that stored procedure I am running another stored procedure where I need to set a variable value. I am not sure how to set a variable of child stored procedure

Is there a way to prevent SQL Server from silently truncating data in local variables and stored procedure parameters?

I recently encountered an issue while porting an app to SQL Server. It turned out that this issue was caused by a stored procedure parameter being declared too short for the data being passed to it: the parameter was declared as VARCHAR(100) but in o

SQL Server: Adds a Column to the Result of a Stored Procedure

I have a stored procedure in SQL Server that executes like this EXEC @return_value = SP @value1 = 'A', @value2 = 'B' and the result is: value3 | value 4 | value 5 I need to add the columns value1 and value2 to the result (yes, the same I use to execu

SQL Server 2005 - Passing a Two-Dimensional Matrix to a Stored Procedure

I am working on SQL Server 2005. Here I need to pass an array (2 dimensional, E.g: Emp No, Emp Name ) having multiple records from my ASP.NET application to a Stored Procedure. Would you please let me know if there is a way to do it? Many Thanks, Reg

How does Sql Server compile execution plans for the logical flow in stored procedures?

I need to use the same query twice but have a slightly different where clause. I was wondering if it would be efficient to simply call the same stored proc with a bit value, and have an IF... ELSE... statement, deciding on which fields to compare. Or

SQL Server 2000: How can I get a list of tables and the number of rows?

This question already has an answer here: Query to list number of records in each table in a database 15 answers I know that I can get a list of tables with SELECT TABLE_NAME FROM information_schema.tables WHERE NOT TABLE_NAME='sysdiagrams' AND TABLE

Can I schedule a job in SQL Server 2000 MSDE?

We are currently evaluation our hosting options and the cheapest suitable option we've found only has SQL Server 2000 MSDE as the db server. Does this have the ability to schedule jobs using SQL Agent? If not, can I use a windows scheduled job to run

Send notifications from a SQL Server 2000 job without an SMTP server on the box

I have SQL Server 2000 installed on Windows 2003 Server. We do not have SMTP installed on the box, so when creating a notification for a failed SQL Agent job, the email is not sent. Is there a way to send out a notification without installing SMTP on

Join a .MDF file created by SQL Server 2008 in SQL Server 2000

I created a database in SQL Server 2008. I detached the database and I copied the .mdf over to the server, which is running SQL Server Enterprise Manager (SQL Server 2000). When I try to attach the MDF I get... Microsoft SQL-DMO (ODBC SQL State: HY00

How to create an extended stored procedure in SQL Server 2000

I need to create an extended stored procedure in SQL Server 2000 using Visual Studio. It worked fine in SQL Server 2008 and 2012. I followed the instructions described here after adding the dll the stored procedure does not run! The procedure to crea

Related Articles