Creating And Configuring JOBs Using Transac-SQL
Sep 17, 1999
I am new to SQL7 (in fact new to Database Management as well).
I am trying to write some store procedures to create and manage JOBs within SQL7 Server. For example, to cause data-migration to a different place everyday at certain time. I have tried to use things like sp_add_job. However, I kept getting messages like "Cannot find procedure sp_add_job" although I can see it under Master database. (I have been refering to Master database when I tried these commands).
What I would like to achieve at the end is to be able to specify and create JOBs entirely using Transac-SQL. (I have made it with the Enterprise manager, but that can not be the solution here. )Any help and tips would be greatly appreciated!
View 2 Replies
ADVERTISEMENT
Sep 21, 1999
I am new to SQL7 (in fact new to Database Management as well).
I am trying to write some store procedures to create and manage JOBs within SQL7 Server. For example, to cause data-migration to a different place everyday at certain time. I have tried to use things like sp_add_job. However, I kept getting messages like "Cannot find procedure sp_add_job" although I can see it under Master database. (I have been refering to Master database when I tried these commands).
What I would like to achieve at the end is to be able to specify and create JOBs entirely using Transac-SQL. (I have made it with the Enterprise manager, but that can not be the solution here. )Any help and tips would be greatly appreciated!
View 1 Replies
View Related
Jan 22, 2008
Hi Everyone,
Can anybody tell me how to create a job which tells me when was the SQL server agent was last started?
View 4 Replies
View Related
Nov 5, 2007
what is the equiv to dtsrunui to create the operating system (CmdExec)....
anyone have a good site suggestions for ssis outside of bol
View 2 Replies
View Related
Nov 19, 2007
Hello I am using SQL Server 2005 I want to delete the data from my table after specific number of days.This should happen automatically. After the days I specified the data from the table should automatically get deleted. Can anyone let me know how to achieve this.If anyone can give an example for this it will be great.Thanks in advance.
View 1 Replies
View Related
Apr 22, 2008
Hello,
We have some jobs that are running on the principle database. I am planning to create those jobs in the mirror database also, so that when it gets failover it will automatically run those jobs. Here is my question, Is there any way we could create the jobs on mirror database also and say not to run (exit) if the database is in mirror role by writing some scripts or by selecting any options? Please let me know. Thanks!
View 3 Replies
View Related
Jun 27, 2015
I created 2 jobs under sql jobs. How to set up the custom category for my new jobs. It is going under uncategorized but I want to create DBA Monitor category.
View 1 Replies
View Related
Mar 27, 2007
Hi allI am looking for examples of scripts that will help me doing these things:
- import a text file delimited with the character "*", representing a new month of data, for example data from march 2007
- create a new table with the structure of an existing one to import the data, for example Data_March_2007
- alter an existing totals table adding a new column for the new moth imported, adding a new colum for the month of March 2007.
View 1 Replies
View Related
Jan 4, 2005
string connectionString;
string queryString;
SqlConnection sqlconnection;connectionString="server=fatyi;integrated security=SSPI;initial catalog=tempdb";
queryString="insert into products values(5,'BaoMa',200596,900000,0)";
sqlconnection=new SqlConnection(connectionString);
SqlCommand addScorce=new SqlCommand(queryString,sqlconnection);
sqlconnection.Open();
addScorce.ExecuteNonQuery();
sqlconnection.Close();
help to find out why? if i use "select" it can transaction in this code. And here "insert" .My WebAplication could work,but have no result of "insert".and no error information.The "insert" purview of "products" table have selected.
I help you can help me to point out maybe where is error.
Thank you !
View 1 Replies
View Related
May 4, 2004
Hi all
I currently have a problem where I need to create a backup from MSSQL, via a command line, ideally from a batch script. This is on a PC. Each machine has SQL Server 2000 on.
I just need to know the code that dos will tell it to run the sql statement. Ideally the command will also give the directory to place the backup.
Regards MiloJ
View 2 Replies
View Related
Jul 20, 2005
HiI need create, write and read text files in a procedure transac sqlfrom sql server 2000How i do this ??Thanks,
View 3 Replies
View Related
Oct 30, 1998
Dear all
Problem and symptoms
We have recently added 1GB Ram to our systems and now we are trying to optimally configure 2GB of RAM for SS6.5 SP4 and we are getting the fllowing error INFREQUENTLY
"Not enough memory for pss allocation"
We have to restart the SQL server/ (recover databases) to get out of this. Since it is a heavily loaded production environment you can imagine the impact!!.
SPECS
OS-- NT4/sp3
H/W -- Dual Processor Alpha 4100
MEM -- 2GB
SQL PArameters:
memory--819200
Worker Threads -- 255
Proc cache -- 12%
Work done so far
There is a recommendation to reduce the memory or stack size parameters ref:Q160683!!
Question
1. I would like to know if anyone has got around a similar problem, and how. 2. As in NT Virtual Memory Manager AUTOMATICALLY brokers the allocation of physical memory between the requesting applications (e.g. sqlsrvr.exe) and the page file and no application can write directly to RAM, what does the memory parameter in SQL config control? Also then how is the above KB article relevant?
I look forward to your response
Thanks and regards
Arun
View 3 Replies
View Related
Apr 25, 2007
Hi all,
I have a question regarding SQL caching.
I want to use SQL caching for my pages.I've gone through http://msdn2.microsoft.com/en-us/library/e3w8402y(VS.80).aspx article on msdn, where in step by step procedure is explained for this. But I have a slightly different situation. In the article, we need to configure our application from web.config by following...
<!-- caching section group --><caching> <sqlCacheDependency enabled = "true" pollTime = "1000" > <databases> <add name="Northwind" connectionStringName="NorthwindConnectionString1" pollTime = "1000" /> </databases> </sqlCacheDependency></caching>
Where in "NorthwindConnectionString1" is the SQLdatasource connection string. But I'm not using SQLDatasource, and have my own classes to build a connection datasource and get a dataset, and then bind it to my control.So in this case what should I write for the above "connectionstring" attribute. My connection string is in web.config only with a section defined. and in my application i'm reading from web.fing only.The connection section i'm using is as follows...
<ConnSettings>
<add key="ConnString" value="server=serverName;database=dbName;uid=dbuser;Pwd=password"/>
</ConnSettings>
I want to know how to configure my sql cache in this situation.
Thanks,
Mehul Mistry
View 2 Replies
View Related
May 29, 2008
Hi
When I try to configure a SQL datasource and I use a Microsoft SQL Server datasource I get a blank drop down list for server name. My aspnetdb is available in SQL Server 2005 and I can log into it through management studio, and the service is started. I am also using Vista Ultimate.
Is there any other configuration I need to do for Visual Studio 2008 to see the SQL Server instance?
Thanks
Kwis
View 2 Replies
View Related
Jun 18, 2001
Hi all,
I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).
Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated.
thanks in advance.
regards..
View 5 Replies
View Related
Apr 4, 2008
Hi All,
I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.
Thank's in advance..
View 2 Replies
View Related
Sep 26, 2007
I new to SQL 2005 and have couple of questions regarding configuring the user. Let me start by saying what I need to be achieved.
1. Create a new user which will be user by couple of people to create and execute stored procedures
2. Deny all permissions for this user to access data from certain tables.
3. Configure the role and permissions for this user so that the above two is possible.
I was able to do the first two steps and when the users uses a query, ( select * from 'that table' ) the result in a permissions error. Also that user cannot view the table in SQL manager
The problem now is that that user can create a stored procedure that has the SQL statement Select * from 'that table' and execute the stored procedure to view the table.
The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this?
I am trying to resolve this issue for a while now and any help is greatly appreciated.
Regards,
View 7 Replies
View Related
Aug 4, 2005
Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V
View 1 Replies
View Related
Jan 7, 2008
Can someone help? I am new to Visual basic programming and have down-loaded Visual Basic Express. I followed the instructions for creating my first database but when I got to making the SQL database I got the following error message. " Generating user instances in SQL server is disabled, use sp_configure "user instances enabled" to generate user instances" Where do I find sp_configure and how do I start it.
View 1 Replies
View Related
Mar 28, 2007
While configuring reporting services, in the database setup section, I am entering the instance name connecting to, and the user-id details. On applying the changes, i am getting an error that "Using other edition of database for reporting data sources and/or report server databases is not allowed in this version of Reporting services"
Can anyone help me resolve this issue?
Thanks,
Vijay
View 5 Replies
View Related
Sep 27, 2006
wasnt sure which forum to put this in - so i'll attempt here!
i have been trying to setup SQLMail in SQL2000 but have been having a few problems
i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account
i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.
so i assumed that was all thats needed??
through Query Analyzer i run a simple test
EXEC xp_sendmail 'Craig.Gamble@<mydomain>.com' 'The DB is full'
i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent
i also checked the SQL account permissions to make sure it could access the Exchange Server using the
EXEC xp_cmdshell 'NET USE \EnterpriseIPC$' and again this returned success
so now im stumped!
is there anything else i can check to see where or what its supposedly sending??
any help greatly appreciated.
Cheers,
Craig
View 1 Replies
View Related
Aug 26, 2006
I have a site with roles/membership working fine on my local machine, but I am having serious trouble deploying it to a shared host. My hosting provides a sql 2000 database, but the user created for it that I use is not dbo. I am errors when I try to access my site such as Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'The procedure was created under my user, so it's there, but it's full name ia myusername.aspnet_CheckSchemaVersionHow can I tell the asp.net membership/role provider to use my username instead of dbo when it looks for objects? Thanks
View 6 Replies
View Related
Oct 31, 2007
In a web site the user has to choose one out of several sql tables to deal with.
He will then be allowed to view the selected table data through a GridView, to insert a new row into and to update a row in the selected table by means of an array of TextBoxes created dynamically on the base of the selected table.
I think it is possible to solve the problem fully by properly configuring at run time an SqlDataSource.
I have solved the issue of data display by declaring in the code behind within the OnPageLoad sub the following:
SqlDataSource1.SelectCommand = "Select * FROM " & selectedTable
While for the GridView1 I have added the selected table columns to the columns collection as follows:
for i=0 to ColumnCount-1 Dim cac As BoundField = New BoundField
cac.HeaderText = HeaderNamesArray(i)
cac.DataField = ProductNamesArray(i)Me.GridView1.Columns.Add(cac)
next
I have difficulty on how to do similar declarations for the insertcommand and update command.
View 2 Replies
View Related
Jan 4, 2008
I have several Sql Tables, each containing more than 100 fields, on which I need to perform display operation through GridView, Insert and Update through an array of dynamically created and databound TextBoxes.
I would like to use a single page to manage all Sql Tables on the basis of the name of the specific one invoked by the user.
In order to achieve that, I need to dynamically configure the SqlDataSource Web Control present on the page for each Sql Table. In particular I need to generate at runtime the InsertCommand and the UpdateCommand.
On how to do it I have no idea.
Federico
View 2 Replies
View Related
May 29, 2008
hi all i try all date convertion function that u imagen in my asp.net project to insert a date to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00"
how can i fix that from sql server
plz
View 8 Replies
View Related
Dec 22, 2003
Hi,
I've two servers on which there is the SQL 2000 Server and the IIS 6.0.
I installed the SQL Server Client Tools on web server.
And created the nwind as told in booksonline.
I declared the SQLXML extention and allowed it using IIS 6.
But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.
The web server shows the following error.
ERROR: 500 Internal Server Error
HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings
Thanks for any suggestions.
View 2 Replies
View Related
Feb 26, 2006
When I configure a SQLDataSource control I want the following where clause...
WHERE (RegionID = @RegionID AND DistrictID IS NULL AND CampusID IS NULL) OR (DistrictID = @DistrictID AND CampusID IS NULL ) OR(CampusID = @CampusID AND UserRole = 'CampusAdmin') OR (CampusID = @CampusID)but it gets reformated as....
WHERE (RegionID = 'Region10') AND (DistrictID IS NULL) AND (CampusID IS NULL) OR (DistrictID = 2) AND (CampusID IS NULL) OR (CampusID = '999999103') AND (UserRole = 'CampusAdmin') OR (CampusID = '999999103')I don't think these are functionaly equivelant, are they?If not how do I stop the 'wizard' from reformatting the SQL where clause?Thanks
View 3 Replies
View Related
Apr 14, 1999
How can I configure my workstation running WIN95 to used the SQL Enterprise Manager from the server end and other utilities. I have installed the client network utility.
Reason to use enterprise manager because I wanted to perform administrative tasks on my workstation and I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.
Can anyone helps?
View 1 Replies
View Related
Mar 2, 2006
Hi all,
Need some help with configuring the Disk Sub system using Raid 10
1. What shud be the disk configuration to have 4000 inserts per second on a RAID 1+0 ?
2. What is the best way to maintain a Hot Stand by Server for a very high OLTP system ( say for a day Trading Database ).
Thx
Venu
View 3 Replies
View Related
Jul 7, 2007
hi,
I need to connect my Local Database from SQL Server to the Web Database.
I need to know what all things to be done for completing this process. Some one please please help me with this.
Ad if this information is not enough, please do ask me any question regarding this and iam ready to answer them.
One more thing, iam not that familiar with SQL Server 2000 but i can manage to do things.
So please do help me on this.
Clever_Idiot
View 4 Replies
View Related
Jul 20, 2005
I am running Microsoft SQL Server 2000 - 8.00.760 Enterprise Editionon Windows 2003 Enterprise Edition (NT 5.2 Build 3790:) I have 4CPUand 8GB of RAM. I have AWE enabled, /pae /3gb switch is on inboot.ini, In my errorlog I have noticed few times error messages as"The SQL Server cannot obtain a LOCK resource at this time. Rerun yourstatement when there are fewer active users or ask the systemadministrator to check the SQL Server lock and memory configuration.." I haven't modified anything in sp_configure 'locks', so i amassuming SQL server is dynamically managing the lock memory. Runningperfmon for few days I observed that Lock Requests/sec are usually few100,000 most of the times and sometimes goes to 2+ million. However Ihaven't seen Lock Memory (KB) going more than 40MB. So i wonder why amI seeing the Error: 1204 in my sql log ? And any advise on how toprevent it.ThanksAswinee
View 1 Replies
View Related
Jun 9, 2006
I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is 'ASPNET' in "SELECT @s = @@servername + 'ASPNET'"
Also what is 'webuser'
---Configure Doctors
USE doctors
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + 'ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GO
GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser
GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser
GO
Can anyone help me how to solve my problem?
Your help would be very much appreciated
Thanks and Regards
Kavitha
View 1 Replies
View Related