SQL Server 2000 Jobs

Mar 14, 2005

Hi,

I have installed SQL server 2000 (Enterprise) on W2K advanced server using my local "Administrator" account. Using the same account for login, I have created database backup jobs on the server. After this I rename the Windows administrator account to "admin". Now I see that the jobs started failing. The error message indicates that "could not determine whether the 'server/administrator' account has access to SQL server."

Further, when I tried to troubleshoot, I discovered that the job owner name still displayed (through EM) is "server/administrator" account (this account is now renamed). I tried to change the owner name to "server/admin" but it is not getting changed. Hence, I just created a Windows user named "Administrator" and see that the Job is executing successfully.

Please note that the backup is taken on the server itself and SQL server & Agent services are running under security context of a domain account having administrator priveleges on the server.

What I am interested in knowing is what are the reasons for such behaviour? And how to rectify this problem since i really don't want the "administrator" account to be created.

View 6 Replies


ADVERTISEMENT

Sql Server 2000 Jobs...

Jan 10, 2007

Hi. i'm new to sql server jobs as i have never used the feature manually before. here is what i want to do but i don't know if it's possible.

we have a report we use that's accessed from an asp page. currently, the page uses a stored procedure to generate the data. well, as time has progressed, we've added many items to the report. it now takes a good 15-20 seconds to pull the report. what i want to do is run a job that will compile the data for me and just dump that information into a new table. does that make sense?

can this be done with sql server jobs? thank you.

View 6 Replies View Related

Granting User Access To Run Jobs In SQL Server 2000

Apr 21, 2008



Dear all,

I want to grant a user permissions to run Jobs in SQL Server 2000. I can' seem to find any appropriate roles for that. Do I need to assign him a server role? In that case, which? Many thanks.

Pedro Martins

View 1 Replies View Related

How To Programmatically Reschedule/schedule Jobs In Server 2000 And 2005 ?

Oct 3, 2006

Hi,

how to reschedule/schedule jobs in server 2000 and 2005 Programmatically?

thanks

sandipan

View 1 Replies View Related

SQL 2000 Jobs Disabled On It Own

Nov 1, 2007



Hi,
I have been scheduling jobs from past couple months on production but it does not execute on the scheduled time.

I checked the schedule enabled tab, it was enabled when i scheduled the job, but was disabled at a later date when i checked to see why the job did not run.......

Can some one please guide me if there is any process in SQL which disables the jobs automatically.

I want to find out how the jobs when scheduled and enabled gets disabled on its own.



View 1 Replies View Related

MSSQL 2000: Scheduling Jobs?

Sep 22, 2006

Yao,
Could anyone help me with, or point me to information regarding, scheduling jobs for MSSQL 2000?  I need to execute a SQL Command, monthly, which sets a budget field to a fixed ammount, something like:  UPDATE Programs SET Budget = 500.
--Kyle Johnson 

View 1 Replies View Related

Jobs Migration From SQL 2000 – 2005

Mar 19, 2008

I am trying to migrate few of my SQL jobs to SQL2K5. Can I simply script and execute them on the new environment. I hope the script is forward compatible.


------------------------
I think, therefore I am - Rene Descartes

View 2 Replies View Related

SQL 7 To 2000...how To Transfer User Id's, Jobs, And DTS Packages

Feb 11, 2003

Hello,

I want to move a db from a SQL server 7 to SQL Server 2K. I'll do a backup and restore function to move the database, but how do I handle the objects mentioned in the header ?

Bothe servers (old and new) will have the same name, as well as the DB

All help is appreciated !
Thanks

View 2 Replies View Related

To Transfer Maintaenance Plan And Jobs From SQL 7.0 To 2000

Apr 25, 2002

We've upgraded our SQL7.0 user db to a SQL2000 system using sp_detach_db and sp_attach_db stored procedures.
And we'd like to transfer our sched jobs from a SQL 7.0 to SQL2000 systems,
if the jobs are created outside a maintenance plan, we can script them out and run the script to recreate them on the 2000 system.
But if the jobs are within a maintenance plan, we would have to recreate these plans manually on the 2000 system, is this the only option we have ?
Any one has a better solution ?
I think "restore msdb from abackup" should work better in this case?

In SQL2000, there is a new DTS task for transferring jobs between 2000 systems (same version), but I don't think it work to transfer them from 7.0 to 2000 ??
Anthony

View 3 Replies View Related

Running 2005 SSIS Jobs On 2000

Sep 10, 2007

I would like to create an SSIS package in 2005 and run it in 2000. Is there anyway to do this? Or does SQL Server 2000 have a precursor to SSIS? I am trying to create a job to automatically catch and kill orphaned processes.
-Kyle

View 1 Replies View Related

SQL 2000 Maintenance Plan And Multi-step Jobs

Mar 9, 2006

Hi,

I'm working with SQL 2000 and am just learning about Maintenance Plans (MP). They seem convenient, but after some time, I'm wondering if they're the best approach long-term. Here are my experiences.

Using the MP Wizard, I created a plan with tasks from all the dialogs:

- Optimize database
- Check integrity
- Backup database
- Backup transaction log
- Write a report

I was puzzled to find 4 jobs were created, each with just 1 step, and staggered starting times. I expected to find 1 job with 4 steps. So, brimming with confidence, I did just that. I combined all 4 into 1 job, deleted the 3 other MP created jobs, and checked for any job-specific details in the code. However now when I open the MP, I get this pop-up:

"One or more of the jobs created for this plan has had additional steps added to it. It is not recommended that jobs created by the maintenance plan be modified in any way."

Okay, fair warning. Yet it appears the job and all steps run successfully, both on demand, and on a schedule. So now I'm wondering if jobs always need a MP. If I don't mind working with xp_sqlmaint syntax, it appears the only thing I'm giving up is the MP history. But I expect job history and '-WriteHistory' will minimize that loss.

I searched BOL, this Forum, and Google, and found a couple articles. One author preferred the ease of the Wizard, another preferred the control and added features of T-SQL, but both created a MP in their examples. So I'm hoping some experienced DBAs can advise.

If I create a job with multiple steps, and no MP, are there important things I give up or problems I create?
Is this approach a bad idea in SQL 2005?

At this stage, I don't need replication or other advanced features. Just simple database maintenance.

Thank you,
- Martin

View 1 Replies View Related

SQL Server Jobs

Apr 29, 2002

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

View 4 Replies View Related

SQL Server 7 Jobs

Jul 26, 2001

When I change the SA password on my server the current SQL Jobs no longer
work. How can I fix or get around this problem without rebuilding my jobs?

View 1 Replies View Related

Jobs On SQL Server 7.0

Jan 3, 2000

Hi there and happy newyear

I have a very annoying problem with my SQL Server 7.0

Here is the story:
In our compagny we have three SQL servers, SQL1, SQL2 and SQL3. The SQL1 server is our development server where we build our databases. When they are ready to go live I make an DTS package that copies the database to SQL2 and put it into a schedule.

Is it somehow possible to execute a job on SQL2 when the job on SQL1 succesfully has finished??

Cheers

Dennis

View 5 Replies View Related

DB Engine :: Trigger Jobs On Remote Server To Do Its Work On Original Server

May 10, 2015

I'm new to SQL. I have a scenario, Where customer want to move all the jobs from original SQL server to some remote SQL server and want to trigger jobs on remote server to do its work on original server.

View 4 Replies View Related

Can We Create Jobs In Sql Server?

Sep 6, 2007

 Can we create Jobs in Sql Server?

View 3 Replies View Related

Jobs In SQL Server Agent

Apr 9, 2001

Hi All,
I am not able to see any of the jobs in the enterprise manager that are scheduled on one of our production servers. Have any body seen this type of behaviour of SQL server.. The jobs are there in the SQL as I can query sysjobs table to see there entry.. The jobs are being executed properly when they are supposed to..
Thanks
Ajay

View 2 Replies View Related

Transfering Jobs From One Server To Another

Aug 7, 2000

Hi
I need to copy all the jobs from one server to another server. How i have to do. I tried to take script of MSDB database, but it is not scripting all the jobs. PLs anyone suggest me what i have to do with scheduled jobs in 65.
it is very urgent pls.
thank u
--Rk

View 1 Replies View Related

SQL SERVER JOBS FAILING

Jun 27, 2000

I have created DTS packages to export data to text files....these packages are
running...the jobs that are created to run these packages are failing ...
both the SQL SERVER and the SQL SERVER AGENT are running administrator accounts ...if the job step is run on the command line it works..so basically
some permission that invokes the the command shell is missing...jobs that run just T-SQL steps work fine too....what am i missing out?

View 1 Replies View Related

Moving Jobs To A New Server

Jan 21, 2001

Hi,
I have to move my SQL server data from win95 to NT.
When it comes to databases I would execute attach option.
When it comes to backup devices I think I could simply copy the folder where
backup devices are being located? IS it true??
How about moving jobs; DTS and Database Maintenance Plans???
Any Ideas??
Thanks,
Andy

View 1 Replies View Related

Moving Jobs From One Server To Another

Oct 19, 2000

Hi ,

I need to move databases and related jobs from one server to another.

I can move the database no problem. how can I get jobs moving.

Pls help me

Sunthar

View 1 Replies View Related

"Copying" Jobs From One Server To Another

Aug 26, 1999

Hello -
I was curious if there is any way to "copy" a SQL Job, alert etc. from one server to another. I want to test jobs on a non production server before putting them out on our live Server. I understand you can do the whole Master server thing, but this temp server is often rebuilt for whatever we need.
Any insights would be greatly appreciated...
Thanks in Advance.
Joe

View 1 Replies View Related

SQL Server Jobs Programming

Mar 1, 2004

I got troubles when I program a DTS package to a job. The job simply does not run.

What can I do?

Thanks for your quick answer!!

Cristopher Serrato

View 2 Replies View Related

SQL Server Administration Jobs

Mar 27, 2007

(Post removed)

View 3 Replies View Related

Jobs In SQL Server Agent..

Apr 4, 2007

Hello all,
we just moved our databases over from a SQL 2000 server onto a new SQL 2005 server. We had no problem migrating them over, but was wondering if there was a way to migrate the jobs over as well. We have about 20 of them and would prefer not to hav to create them all again on the new server.

Thanks in advance,
Phoenix

View 1 Replies View Related

Can't Create Jobs In SQL Server 64-bit

Jan 29, 2008

I am creating a job for integration services in SQL server 2005 64-bit edition. I am getting error :The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI). Please help

View 3 Replies View Related

Jobs Running On The Server

Mar 30, 2008

hi every 1,
i am having a real tough time to figure this one out .

i need to find out what jobs are schedule in the server that sends data out to ever .
we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server .
i looked at the sysjobs_view , it tells the origination server and all the jobs that are running on it, but that's pretty much it.
on the sql agent , i see all the jobs but dint know which jobs are sending data out side the server .
some jobs are regular backup
maintenance jobs
how will I figure out which once are gong out .
hope you people can help . any help will be so much appreciated.
bobby

View 3 Replies View Related

Copy Jobs From One Server To Another

Jun 27, 2007

How do you copy all jobs from one server to another? Is there a way to do this programatically?

View 3 Replies View Related

Who Should Own Jobs In SQL Server 2005?

Mar 15, 2007

Hi,

Who should own job in SQL Server 2005? Currently, I have set up a couple new jobs, the owner is a windows login with administrative privileges on the server. So the job runs fine.

When I tried to change the owner to a non-admin user, the job failed, stating that I needed to set up proxy permissions or something to that effect. So I left the owner as the admin user.

Is that ok, or even the preferred owner of jobs?

Also -
One of my job steps is calling an SSIS package. On the "general" tab, it shows that it will run the package as the SQL Server Agent, and then there is a section "Log on to Server" where you select windows or sql server login info. In this case, I the SQL Server agent is a different windows account than the job owner... so who is logging in at the package level - the job owner or the SQL Server agent account?

Thanks very much

View 3 Replies View Related

How To Move Jobs To Another Server?

Jan 15, 2008

I have hundrends of SQL Agent jobs in SQL Server 2005 and I want to move them to another server everyday for DR purpose. I try to restore the msdb to another server but it seems that proxy could not match the credential on that server even the credentials have same name. Any suggestion for me to move jobs each night? Thanks in advance!

NIck

View 4 Replies View Related

Creating Jobs In SQL Server 2005

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

Sql Server Scheduled Jobs Question.....

Apr 14, 2008

i have a package scheduled in sql server.....
if i change something in the package and save the change...
will the scheduled job then reflect that change? or does the scheduled job have to be deleted and the package re-scheduled in order for the change to take affect?
(for example....i have a scheduled package which pulls some data from an oracle server and populates a sql server tabel. well....the oracle server has changed. so if i open my package and change the oracle server connection and save it, will the scheduled job have this change?)
 

View 1 Replies View Related

How To Open SQL Server Jobs Window From VB. NET

Aug 17, 2005

Hello guys,I've one query regarding accessing SQL Server. I want to use SQL Server jobs scheduling functionality. Is it possible to open SQL Server's jobs window from VB.NET? (Server -> Management -> Jobs) Pls. help me to solve this query. Thanks in advance. Waiting for yr reply.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved