SQL Server 2000.
Hey there,
I'm trying to set up a test environment. My projuction environemtn has a bunch of Scheduled Jobs which run either stored procedures or DTS jobs.
I've exported the SP's and the Scheduled jobs but I'm wondering if there is any way to migrate the DTS jobs?
Cheers...
Hi,It may sound funny but it is true. I have 2 version of same procedure, 1 is named as "update_aggre" other named as "update_aggre_2" .if I run these procedures using sql jobs the 1st procedure takes 12 seconds and the 2nd takes 2 second. I am stil surprise why is that both of them have same code.Any ideas please?and also I need to have lock mechanism within a procedure so that if some one is calling a procedure which is already called by some one ans is stil working on it the second user shld not be able to overwrite the existing data untill the first one is finished.TIAAmit
View 3 Replies View RelatedWe're upgrading to Sql 7 from 6.5 but having problems running jobs with the following sql statement :
SQLMAINT.EXE -D master -BkUpDB e:dump -BkUpMedia DISK -DelBkUps 2 -Rpt d:salogmaster_dump.log
The error message is [Microsoft SQL-DMO (ODBC SQLState :28000}] Error 18456:[Microsoft]ODBC SQL Server Driver][SQL Server]Login failed for
user 'Domainuser'. Process Exit Code 1. The step failed.
The user is a domain account and already in local administrator group. It also starts up both Sql server & Sql server agent. It can run the same job on another server. I have compared the set up and can't find any differences.
Thanks in advance for your help.
If i've created myself a job on my SQL Server and then scripted it, how do i run this script and so doing create my job on another server?
View 2 Replies View RelatedHi, I have a DTS package that runs correctly when executed manually, but when I schedule a job via the package, the job begins executing and nevers seems to complete the run. The Package runs in less that 1 minute, but the job sticks on executing and does not complete. I have to cancel, any ideas?
Thanks
I have 12 scheduled daily jobs, all the jobs are depending on one job.I want to run rest all the jobs if and only if the Job#1 gets success.Now all are running independently.Is there a way to force the sequence by using SQL.
Thanks!
If we have several jobs running several times daily,do we have to do any clean-up with the logs/job history so that they don't run into any problem later?Will it be o.k if we do not clear off the history frequently?
View 2 Replies View RelatedHi all,
My firm has about 15 SQL Servers. 5 of them are still 6.5 and the other 10
are 7.0. I have noticed that the jobs I have setup to perform maintenance
tasks, backups etc. almost never fail in 7.0. Similar tasks routinely
fail on the 6.5 servers.
So I did a test. I deleted a database in 7.0 and ran a backup job. Although
the log for the job said that it couldn't find the db it still said the job
was successful. In 6.5 if you try to run a job on a non-existent db it
fails. What's going on in 7.0? What has to happen for a SQL Server agent job
to fail. This seems like an awfully dangerous new "feature".
If anyone could shed light on this I would appreciate it.
Thanks
JJ
Hi,
How do we add DTS pakages to a scheduled job ?
Ex: Lets say i have 2 DTS pakages One has got to run immediately after the other.
>Now i create a schedule for the main DTS pakage.
>Once i create a schedule, It goes into Jobs as a Scheduled job.
>Now in the propertied part of the first DTS job i need to add a second DTS
as Step2, mentioning that it should run after the First DTS.
How do we do this ?
Thanks in Advance,
Siv
Does anyone know how I can set up some form of alert that tells me which scheduled jobs are still running?
View 1 Replies View RelatedWe had some jobs in Sql server 7.0 which ran together at the same time.
Now we have moved to sql 2000 and when we run those jobs together again they just sit up(keep on going without doing anything) and do nothing.I have monitored that there is no Blocking or any kind of Performance Overload.
These jobs run fine when they are executed Individually in Sql 2000
Any kind of help will be appreciated.
Thanks,
James
hey guys!! can someone tell me, what are jobs on MS SQL?
and what is a job scheduler? how do it function? what are the processes
involved? and additional information about this stuffs.. thanks..really need it.. tnx tnx..
p.s.
if your wondering
why i asked the questions
here..because it's really
hard to search the meaning
of it in the net..i hope you
guys could help me.. tnx
Thanks for the help with moving jobs from one server to another.
Now that I have moved them, they now fail each and all. I have copied the script and saved them as vbs files and placed them in a folder on the server and ran them successfully. I think it has something to do with the rights, but I don't know what. Could someone shed some light on possible causes?
Thanks,
Lee
Hi SQL Guru's
I am trying to run a job on Multiple SQL Servers in a domain.I am setting the job on my system,but the Radio button "Target Multiple Servers" is disabled.How do I enable the radio button "Target Multiple Servers".
Please let me know if this is possible.
Best Regards
SK.
http://www.dbforums.com/forumdisplay.php?f=246
View 6 Replies View RelatedWhat's the best way to backup jobs in SQL Server 2000?
View 3 Replies View RelatedI need some direction on SQL Jobs.
I can handle the setting up a SQL Job/DTS Package.
What I have is SQL Statement I need to run that creates a txt file Renames file to AUX_Export_020507.txt then zips that text file and Name it AUX_Export_020507.zip. Then move the zip file to a FTP directory.
I would like to get email after it runs also.
This issue I am having is the Part that zips the file
Renames the text file and zip file to add the current date on end like I have above and move it to a FTP directy..
The old days we would creat an autoex.bat file to move and rename.
Thanks
Michael Webb
Hi All,
I want to create a job which will basically fetch the information from the system. I mean job will fetch the following information about disk available in the system.
1) Drive
2) Total Size
3) Available Space
4) %free space
Suppose I have 3 drives d,h,i
The information should look like this
Drive Totalsize Available Space %free space
H 2 Gb 1 GB 50%
Can anyone please help me.
Regards,
Frozen
I already learned SQL by reading "Head First SQL" book (which uses MySQL). I also know how to use Excel(using basic function and creating pivot table.) However, I noticed that many available jobs require Microsoft SQL Server 2005 and also using SQL with Excel. Now, I am thinking to learn SQL Server 2005 Express Edition because it is free! I would really appreciate if anyone who has been working in industry give me some suggestions about what is the best way to learn SQL Sever 2005? or does it worth to learn? or is it hard to learn? Can you recommend good book or website for learning SQL Server 2005 Express Edition. Thanks!
View 3 Replies View RelatedHow is it possible to schedule a job to run every 40 seconds.
It seems every 1 minute is the shortest time available in the job properties for scheduling a job.
Thanks
I have 2 jobs
in first job,there are 2 steps
in the 1st step it has to take the backup
in the 2nd step it has to call the 2nd job
in 2nd job,it has to restore the backup
i dont know how to call another job in the second step and one more thing is the restoration is done on another sql server instance
I have to create 2 jobs,The first job has 2 steps,in the last step of the first job,i have to call the 2nd job,How????Can any body help me?
View 1 Replies View RelatedIs there anyway(trigger) so nobody can delete the jobs in SQL Server?Actually we have 4 people who has SYSADMIN rights in that server and just wanna track out.No information is recorded in error logs and application log.
View 4 Replies View RelatedHi
I built a new sql server database and want to export its content to a .sql file. How to do it? (EM, QA ?) Thanks
I have a SQL database with about 600 tables. Is there an easy way to export all tables into individual excel files?
Thanks,
Ken Nicholson
Sara Lee Corporation
I need to export my data using DTS into a csv text file but with fixed
record length
ie: "data ","more data ","data "
and so on - is there an easy way to do this? - when you setup the
destination text file it appears to be a choice between one and the other.
Regards
James Bevan
Hi, I'm new to SQL sever and am using SQL Server Management Studio Express 2005.
I've written my query that returns too many rows to be looked at Excel, and so wish to view and perform my calculations in SAS.
However, I don't know how to export the data I am getting in to SAS. I have tried using the Results to File option, but when I try import this into SAS it doesn't like the data.
Is there some option I need or is there anyway I can export the data to SAS.
Thanks a lot.
Nesu.
Hi,I have a bunch of stored procedures (some using temp tables) which giveout tables which are then used in crystal to give out reports. Thesestored procs are run dynamically depending on values users select onformsSome people instead of reports want Comma Seperated Files (CSVs). I amtrying to find a good way of outputting to csv with using either sqlserver or ASP. I tried two ways but none of them were ideal1st methodfirst way i tried was creating a record set in asp and then using thefollowing to output the data in a comma delimited row and writing tofile.Response.Write RecordSet.GetString(,,", ",vbCrLf,"")The problem with the above was with data sets greater than 10,000records the processing time increases exponentially because of memoryusage ( i found other people with the same problem)So i tried the following2nd methodI used bcp using the master.dbo.xp_cmdshell command to output thecsv. The problem with that is that the bcp executes the stored procthree times and also doesnot give out column headers. So i had to runthe stored proc once in ASP and get the headers from the record set andstore it to a text file and then run the stored proc in bcp and sendthe output to a csv file. Then merge the two files into a third file.The problem with this method is that it takes around 4 times as long torun as just the stored proceedure and also i have to create 3 filesinstead of one.I would appreciate any suggestions you have to output the csv from astored proc in sql server. Note users have to do this dynamically whenthey submit a form so cant use the query analyzer or enterprise managertools.Thanks for your time and help:)
View 4 Replies View RelatedI have a report which is just a simple table with only the detail row (which then as about a dozen columns)
I have uploaded this to report manger. The report generates correctly and I export to CSV.
But when I open the CSV file there are Headings at the top. I want to know is there any way of getting rid of there headers so it is jus the data which shows.
(The headers seem to be the name of the textbox column in reporting services)
I'm not sure if this is possible or not, still new to RS. I need to export a file in CSV format but a vendor needs the very first character to be a '~'. I've tried adding that to the first column name without sucess and RS won't allow me to name it with the ~ in the properties box. Any ideas? Thanks
View 1 Replies View RelatedHi ..
i have a task to monitor the sql jobs..
i wish to do with this with C# or asp.net application.
please help me to finish this..
I have scheduled a T-SQL job that runs every morning using Enterprise Manager. Now I want to change the SELECT and UPDATE statements that this job runs, but I can't find anywhere to edit a job that has already been scheduled. Any help would be appreciated.
Thanks
I have moved my database recently from a NT server to a Windows 2000 server, both running SQL 7.0 I have a couple of jobs that sometimes, work, sometimes not, the problem it tells me is that it cannot find the file specified, I run the job from enterprise manager and it runs just fine, it'll run here and there but it still fails frequently. Any suggestions on what to check? Thanks.
Bob