Sql Executive Jobs

Mar 19, 2001

Hello,

I have registered a Sql server on my local machine.

I can adddelete jobs to the Task Scheduler, view job histories etc on
that server however, when I try to execute a job on that server using the Task Scheduler, I get the following error message:

"The sqlexecutive servive is currently not running on server <server name>. This prevents the task from running".

I have checked the SqlExecutive service on the server and it is running.
I have jobs that get executed each night via the Task Scheduler

Does anyone have any idea of what the problem could be ?

Regards,
Hitesh

View 1 Replies


ADVERTISEMENT

SQL Executive

Mar 15, 2001

Hi all! Does anyone of you know what port number SQL Executive is using? Is it separate from the SQL Server's 1433?
I have a user who is behind a firewall. He can connect to sql server but he can not run a task manually. If the task is scheduled it is successful but
if he run manually , sql server display "The SQL Executive service is not currently running on <servername>. This prevents task .... from being run."
Eventhough the service is running and other jobs are successfully.

Would it be possible the port for SQL Server is open to that user but not the
sql executive.


Thanks in advance.
Zrxowm

View 3 Replies View Related

SQL Executive Using 6.5 And 7.0

Oct 27, 2000

i have both SQL Server 6.5 and 7.0 installed...for some reason i cannot start SQLExecutive while operating on 7.0...when i try to start the service it says 'Yu need SQL version 6.5 or later to start SQL Executive'
has ayone come across such an error?

View 2 Replies View Related

SQL Executive

Mar 28, 2002

Having issue starting this service on SQL7 SP2. Returns "specific error 109"
Any tips on resolution--no help on MS site search. what are ramifications of NOT starting this service if it is a single Server and the SQL application we use does not seem to be affected other than problem loading SP3 and is this related?

Thanks for any input

View 1 Replies View Related

SQL Executive

Jan 17, 2000

MSSQL Server, SP4, running under version 6.5.

Is there a way I could use T-SQL to find out if the SQL Executive is running or not ?

View 2 Replies View Related

SQL Executive (SQL 6.5)

Jun 11, 1999

When trying to run SQL Executive from the SQL Enterprise manager it run in a dos window ( all scheduled tasks runs fine).
PS: the machine in question had sql 6.5 installed , removed and then and then re-installed again. this is when the problem started.

Any hint on this subject is appreciated.

Thank you.
Guss

View 1 Replies View Related

SQL Executive Not Running SQL 6.5 Sp3

Mar 31, 2000

MS SQL server error 18450 severity 14

Login failed for user ‘%ls’. Reason: Not defined as a valid user of a trusted SQL Server connection.

does anybody have a clue how to fix this
already cjanged user used for mssql service and sqlexec service

No scheduled tasks can run

View 1 Replies View Related

SQL Executive NOT Visible...

Mar 23, 1999

Hi,

When I register an SQL Server from elsewhere on the network, some of them are not displaying SQL Executive in the Enterprise manager.

Why is this?

View 1 Replies View Related

SQL Executive Problem !

Mar 31, 1999

Hi !

I have SQL Server 6.5 on Windows NT 4.0. Every night i was doing my
backups with SqlExecutive.
Some days ago I had to restart my server. First I stopped SQL
Sevrver,then DTS service and
when I tried to stop SQL Executive it begun to show me the stopping
status. I waited for 20 min.
and status didn't changed. In the Control panel, Services SQL Executive
status is stopped. When I'm
trying to start it from control panel the system tells me that this
service is already running. And now
I can't stop it or start it from service manager.
What could be wrong ? Is it SQL Server problem or NT problem.

Thanks in advance !


Saule@nafta.lt

View 2 Replies View Related

SQL Executive Error

Sep 23, 1998

Hi,

If I execute any scheduled jobs on my SQL Server I am getting the following error message.

`Error 21003 : [SQL Server] Error executing xp_schedulersignal extended stored procedure`

`SQL Executive not running.`

If I check SQL Executive by right click, the drop down menu show start option is disabled.

Can any one help.

Thank you in Advance.

Murali Raparla

View 2 Replies View Related

SQL Executive Problem

Jul 10, 2001

I registered a remote server on my machine that has SQL 6.5 Client installed.
Using the SQL Enterprise manager I am trying to run the scheduled jobs in the remote site, and I get the following error message

"The SQLExecutive Service is not currently running on Server 'Server Name'. This prevents task 'task name' from being run"

I have verified that SQL executive is running in the remote server and I was able to run the same jobs on the same server from another machine. Can you please suggest me as what is wrong with my machine. I have tried to re-install SQL client on my machibe.

I would appreciate if anyone can reply this ASAP as I am stuck.

Thanks
Ganesh

View 1 Replies View Related

SQL Executive And Scheduled Tasks

Jan 19, 1999

I'm running SQL Server 6.5 and have schedules a number of tasks to run overnight. This has generally been successful; even when the tasks have failed, it's been because of a lack of data in a feeder database system.

My problem is that when I try to run the tasks manually, I get a message saying that they can't be run because SQL Executive is not running on the server. Now, this ain't true. The little gizmos show green in the server manager, and if I right click on SQL Executive, 'Start' is disabled and 'Stop' is enabled.

Am I missing something here? Does anyone have any clues or suggestions?

Thanks.

View 2 Replies View Related

SQL Executive Tasks Disabled

Apr 15, 1999

Has anyone seen the following situation?

1) SQL Executive stops running jobs
2) The only way I can get it to START running jobs is to reboot the server
3) When SQL Server and executive come back up, a number of the tasks have been DISABLED! (I have seen this happen over and over on my SQL 6.5 SP4 instances.)

If you have seen this situation, have you found a way to prevent it? (ie: procedure or bug fix, etc.)

Thanks for your help!

View 1 Replies View Related

Problems In Error Log In SQL EXecutive????

Nov 6, 1998

Hi all
Can someone tell me what are these Logs mean.
If you right click on SQL executive in EM and select
Error Log you'll get a list of errors,warnings...etc.

In my Case I get these Errors that are occuring every few seconds.
11/05/98 09:03:10 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
11/05/98 09:03:12 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
11/05/98 09:03:18 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
11/05/98 09:03:28 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
11/05/98 09:03:35 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
11/05/98 09:03:40 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
11/05/98 09:03:46 AM DBLIB ERROR HANDLER: LOGIN INCORRECT

And Warnings:

11/05/98 09:03:10 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not
Associated with a trusted SQL Server Connection.
11/05/98 09:03:12 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not
Associated with a trusted SQL Server Connection.
11/05/98 09:03:16 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not
Associated with a trusted SQL Server Connection.
11/05/98 09:03:22 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not
Associated with a trusted SQL Server Connection.
11/05/98 09:03:28 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not
Associated with a trusted SQL Server Connection.

I have no clue which security i use on the server and on my workstation.
How can one find out which security is being used.



THANK YOU IN ADVANCE.

View 1 Replies View Related

How Can I Turn Off SQL Executive Error Logging?

Jun 29, 1998

I presently have Error Logging turned on for the SQL Executive, but I no longer want it. When I
open up the "Configure SQL Executive" window under the Server menu, the
"Error Log File" field is dimmed and there is no option to turn it off.

How do I turn off logging for SQL Executive?

View 1 Replies View Related

Executive Error Logs---very Urgent

Jul 21, 2000

Hi,
I want to see my sql executive error log but it grown like anything.
How i have to trucate my error log. I cannot stop my server now.
i am getting following message. and also suggest me what i have to do not to grow like this means 56.01 mb size.
The sql executive error log is 56.01 mb in size and loading it will consume considerble memory and may take several minutes to complete.
Now i want to see my executive error log , pls tell me what i have to do.

--rk

View 1 Replies View Related

SQL Executive - Service Startup Account Error

Aug 5, 1998

Hello all,

I just inherited a SQL Server that was set up by a non-DBA. It`s running NT 4.0 and SQL Server 6.50 - 6.50.201 (the vendor hasn`t certified the product on SP4). I am trying to change the SQL Executive Service to use a non-system logon account. The account that I want to use is running SQL Executive on 9 other servers.

I went into Usrmgr and added the account to the administrators group. Made sure that it has rights to:
log on as a service, log on as a batch job, increase quotas, act as part of the operating system, replace a process level token.

When I try to change to that id in services, I get the following error:

"cannot set the startup parameters for SQL Executive service. Error 1057 occurred. The account name is invalid or does not exist."

Looking in Technet, I found that if "log on as a service" isn`t set you could get this message but I`ve check/re-checked, had someone else check and it`s set.

Any help would be appreciated!

View 1 Replies View Related

Dump Database Task Stops SQL Executive

Aug 18, 1998

We are running sql 6.5 with Serv. pack 4. All of our Prod. database are backedup weekly via scheduled tasks. On occasion the dump of a particular database will cause 1 of 2 things:
1. The db dump seems to work correctly but stops sql executive service.
2. The db dump seems to work correctly but sends an alert email msg to me indicating that it failed. The msg in the email is "NO Message".

Has anyone experienced either of these 2 problems or have any solutions?

View 1 Replies View Related

Sql Jobs

Aug 2, 2005

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 Related

Can&#39;t Run Jobs In SQL 7!

Mar 20, 2000

We'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.

View 2 Replies View Related

SQL Jobs

Nov 17, 2000

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 Related

Jobs Won&#39;t Run

Jan 18, 2001

Hi, 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

View 1 Replies View Related

Jobs

Sep 6, 2000

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!

View 4 Replies View Related

Jobs

Aug 30, 2000

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 Related

Jobs In 7.0 Vs. 6.5

Feb 16, 2001

Hi 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

View 2 Replies View Related

DTS Jobs

Mar 5, 2001

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

View 1 Replies View Related

SQL 7 Jobs

Jul 23, 2001

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 Related

Jobs Sit Up Doing Nothing

Sep 21, 2001

We 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

View 5 Replies View Related

What Are Jobs?

Sep 29, 2004

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

View 2 Replies View Related

Right To Run Jobs

Oct 5, 2004

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

View 6 Replies View Related

MS SQL Jobs

Dec 6, 2004

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.

View 1 Replies View Related

Jobs Are Here

Oct 31, 2005

http://www.dbforums.com/forumdisplay.php?f=246

View 6 Replies View Related

Jobs

May 13, 2004

What's the best way to backup jobs in SQL Server 2000?

View 3 Replies View Related







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