Scheduler is hung

I have a SQL 2000 with sp3 recently connected to the NetApps filer. For
the last two days the SQL Server keeps hanging. I can't even log on to
the machine, can't open enterprise manager. We have to bounce the
server. The errorlog indicates:
2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
2004-03-01 17:07:20.38 server The Scheduler 0 appears to be hung.
SPID 0, ECID 0, UMS Context 0x03469860.
2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
2004-03-01 17:07:20.38 server The Scheduler 1 appears to be hung.
SPID 59, ECID 0, UMS Context 0x0346BC48.
2004-03-01 17:08:20.39 server Error: 17883, Severity: 1, State: 0
2004
What does it mean by the scheduler? Is this where the Enterprise
manager runs all the scheduled jobs?
Have any ideas as to what's going on?
Thanks,
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!It could be:
FIX: The Checkpoint Process Can Delay SQL Server Database Activity and Does
Not Yield Scheduler Correctly Causing Error: 17883 to Occur
http://support.microsoft.com/defaul...6&Product=sql2k
Known bug. Call PSS to confirm and get the hotfix.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:uluFM4GAEHA.2432@.TK2MSFTNGP11.phx.gbl...
> I have a SQL 2000 with sp3 recently connected to the NetApps filer. For
> the last two days the SQL Server keeps hanging. I can't even log on to
> the machine, can't open enterprise manager. We have to bounce the
> server. The errorlog indicates:
>
> 2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
> 2004-03-01 17:07:20.38 server The Scheduler 0 appears to be hung.
> SPID 0, ECID 0, UMS Context 0x03469860.
> 2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
> 2004-03-01 17:07:20.38 server The Scheduler 1 appears to be hung.
> SPID 59, ECID 0, UMS Context 0x0346BC48.
> 2004-03-01 17:08:20.39 server Error: 17883, Severity: 1, State: 0
> 2004
> What does it mean by the scheduler? Is this where the Enterprise
> manager runs all the scheduled jobs?
> Have any ideas as to what's going on?
> Thanks,
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Scheduler is hung

I have a SQL 2000 with sp3 recently connected to the NetApps filer. For
the last two days the SQL Server keeps hanging. I can't even log on to
the machine, can't open enterprise manager. We have to bounce the
server. The errorlog indicates:
2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
2004-03-01 17:07:20.38 server The Scheduler 0 appears to be hung.
SPID 0, ECID 0, UMS Context 0x03469860.
2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
2004-03-01 17:07:20.38 server The Scheduler 1 appears to be hung.
SPID 59, ECID 0, UMS Context 0x0346BC48.
2004-03-01 17:08:20.39 server Error: 17883, Severity: 1, State: 0
2004
What does it mean by the scheduler? Is this where the Enterprise
manager runs all the scheduled jobs?
Have any ideas as to what's going on?
Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!It could be:
FIX: The Checkpoint Process Can Delay SQL Server Database Activity and Does
Not Yield Scheduler Correctly Causing Error: 17883 to Occur
http://support.microsoft.com/default.aspx?scid=kb;en-us;815056&Product=sql2k
Known bug. Call PSS to confirm and get the hotfix.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:uluFM4GAEHA.2432@.TK2MSFTNGP11.phx.gbl...
> I have a SQL 2000 with sp3 recently connected to the NetApps filer. For
> the last two days the SQL Server keeps hanging. I can't even log on to
> the machine, can't open enterprise manager. We have to bounce the
> server. The errorlog indicates:
>
> 2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
> 2004-03-01 17:07:20.38 server The Scheduler 0 appears to be hung.
> SPID 0, ECID 0, UMS Context 0x03469860.
> 2004-03-01 17:07:20.38 server Error: 17883, Severity: 1, State: 0
> 2004-03-01 17:07:20.38 server The Scheduler 1 appears to be hung.
> SPID 59, ECID 0, UMS Context 0x0346BC48.
> 2004-03-01 17:08:20.39 server Error: 17883, Severity: 1, State: 0
> 2004
> What does it mean by the scheduler? Is this where the Enterprise
> manager runs all the scheduled jobs?
> Have any ideas as to what's going on?
> Thanks,
> Raziq.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Scheduler appears to be hung

Hi,
I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
two databases that are used continously about two months back to this server
and since then I have noticed this error coming up every 10 to 15 days.
The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
Error: 17883, Severity: 1, State: 0
The SQL Server just freezes and becomes non-responsive. The above error was
present for almost 8 minutes before it started responding. At one time, I
wasn't even able to do a Remote Desktop to the server to check why the server
is not responding and later on I found that it had the same error. Any
information regarding this will be highly appreciated.How many processors do you have running? This implies two, or at least one
with hyperthreading. You might try turning one off completely.
"sharman" wrote:
> Hi,
> I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> two databases that are used continously about two months back to this server
> and since then I have noticed this error coming up every 10 to 15 days.
> The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> Error: 17883, Severity: 1, State: 0
> The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> Error: 17883, Severity: 1, State: 0
> The SQL Server just freezes and becomes non-responsive. The above error was
> present for almost 8 minutes before it started responding. At one time, I
> wasn't even able to do a Remote Desktop to the server to check why the server
> is not responding and later on I found that it had the same error. Any
> information regarding this will be highly appreciated.|||For starters, just set SQL Server to use a single processor under the
instance properties. Also, you might want to apply SP4...
"sharman" wrote:
> Thanks for the information. It has 2 processors. How do I turn off
> hyperthreading and what are the implications of turning it off? Thanks.
> "James Luetkehoelter" wrote:
> > How many processors do you have running? This implies two, or at least one
> > with hyperthreading. You might try turning one off completely.
> >
> > "sharman" wrote:
> >
> > > Hi,
> > >
> > > I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> > > two databases that are used continously about two months back to this server
> > > and since then I have noticed this error coming up every 10 to 15 days.
> > >
> > > The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> > > Error: 17883, Severity: 1, State: 0
> > > The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> > > Error: 17883, Severity: 1, State: 0
> > >
> > > The SQL Server just freezes and becomes non-responsive. The above error was
> > > present for almost 8 minutes before it started responding. At one time, I
> > > wasn't even able to do a Remote Desktop to the server to check why the server
> > > is not responding and later on I found that it had the same error. Any
> > > information regarding this will be highly appreciated.|||Thanks for the information. It has 2 processors. How do I turn off
hyperthreading and what are the implications of turning it off? Thanks.
"James Luetkehoelter" wrote:
> How many processors do you have running? This implies two, or at least one
> with hyperthreading. You might try turning one off completely.
> "sharman" wrote:
> > Hi,
> >
> > I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> > two databases that are used continously about two months back to this server
> > and since then I have noticed this error coming up every 10 to 15 days.
> >
> > The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> > Error: 17883, Severity: 1, State: 0
> > The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> > Error: 17883, Severity: 1, State: 0
> >
> > The SQL Server just freezes and becomes non-responsive. The above error was
> > present for almost 8 minutes before it started responding. At one time, I
> > wasn't even able to do a Remote Desktop to the server to check why the server
> > is not responding and later on I found that it had the same error. Any
> > information regarding this will be highly appreciated.|||Hyperthreading can be diabled at the BIOS level. Most database applications
will experience an increase in performance with HT disabled. Test in your
environment.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:0AEF20A0-A529-42BE-888B-C86BD6957F88@.microsoft.com...
> Thanks for the information. It has 2 processors. How do I turn off
> hyperthreading and what are the implications of turning it off? Thanks.
> "James Luetkehoelter" wrote:
>> How many processors do you have running? This implies two, or at least
>> one
>> with hyperthreading. You might try turning one off completely.
>> "sharman" wrote:
>> > Hi,
>> >
>> > I have a SQL Server 2000 SP3 running on Windows Server 2000. I have
>> > moved
>> > two databases that are used continously about two months back to this
>> > server
>> > and since then I have noticed this error coming up every 10 to 15 days.
>> >
>> > The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context
>> > 0x023339C0.
>> > Error: 17883, Severity: 1, State: 0
>> > The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context
>> > 0x0233C8D8.
>> > Error: 17883, Severity: 1, State: 0
>> >
>> > The SQL Server just freezes and becomes non-responsive. The above error
>> > was
>> > present for almost 8 minutes before it started responding. At one time,
>> > I
>> > wasn't even able to do a Remote Desktop to the server to check why the
>> > server
>> > is not responding and later on I found that it had the same error. Any
>> > information regarding this will be highly appreciated.|||Take a look at this excellent MS whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx
Linchi
"sharman" wrote:
> Hi,
> I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> two databases that are used continously about two months back to this server
> and since then I have noticed this error coming up every 10 to 15 days.
> The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> Error: 17883, Severity: 1, State: 0
> The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> Error: 17883, Severity: 1, State: 0
> The SQL Server just freezes and becomes non-responsive. The above error was
> present for almost 8 minutes before it started responding. At one time, I
> wasn't even able to do a Remote Desktop to the server to check why the server
> is not responding and later on I found that it had the same error. Any
> information regarding this will be highly appreciated.

Scheduled DTS Package not running

I have a DTS package setup that runs just fine when I fire
it off as a DTS package, but when I schedule it to run it
fails.
I'm running SQL2K, sp3. SQLAgent is running.
Has anyone seen this before ?
TIA...
Michael.What is the package trying to do when it fails? This can happen because of
privileges (or lack thereof) of the SQL Agent service account that differ
from the privileges used when running the package from Enterprise Manager.
Bob
Microsoft Consulting Services
--
This posting is provided AS IS with no warranties, and confers no rights.|||as indicated before it depends on a number of things . .
1) if DTS references a file that SQLAgent Account cannot Access/does not hav
e access to
2) if non-sysadmin created SQLAgentJob and SQLProxy a/c exist then job will
be executed in SQLProxy a/c context
3) if DTS is executed using exec xp_cmdshell 'DTSRun' or xp_cmdshell exists
inside DTS and SQLAgent job creator account does not have rights to execute
xp_cmdshell and no sqlproxy account then could get the problem.
hope this helps|||The first part is an ActiveX script that gets file names
off a dir. and inserts them into a table.
The acct mesSQL01 is the account that SQL logs in under as
well as SQLAgent. It is also the owner of the DTS Package,
and has full control on the dir that it is looking on.
heres the fail message that is returned by sendmail:
STATUS: Failed
MESSAGES: The job failed. Unable to determine if
the owner (WILL\mesql01) of job GetFileName has server
access (reason: Could not obtain information about Windows
NT group/user 'WILL\mesql01'. [SQLSTATE 42000] (Error
8198))
I'm gonna start tearing it apart to see if there are other
parts of it that it CAN run. I am quite at a loss here.
Thanks for your help !!
m.

>--Original Message--
>What is the package trying to do when it fails? This can
happen because of
>privileges (or lack thereof) of the SQL Agent service
account that differ
>from the privileges used when running the package from
Enterprise Manager.
>--
>Bob
>Microsoft Consulting Services
>--
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Ok, I think I've nailed down what is causing it to fail,
but I can't seem to find a solution.
Here's the ActiveX script...
Function Main()
Dim FSys
Dim Folder
Dim Files
Dim Comm
Dim Conn
Set FSys = CreateObject
("Scripting.FileSystemObject")
Set Folder = FSys.GetFolder
("\\fsq\Files\DM\Lab\TechReports")
Set Files = Folder.files
Set Conn = CreateObject("ADODB.Connection")
Set Comm = CreateObject("ADODB.Command")
With Conn
.Provider = "sqloledb"'
.open "Data Source = fsq\Mes_SQL01;
Initial Catalog =Lab Tech Library; User id=MesSQL01;
password=xxxxx"
end with
Set Comm.ActiveConnection = Conn
It all works with the WITH statement stuff rem'ed out, so
it's the stuff in the WITH statement that is causing the
fail, even though the MesSQL01 acct is a Domain account,
and has Admin priv on the SQL server. It even fails when I
log on as MesSQL01 and run the package local.
Why would this fail, even though it has the permissions ?
This is the domain acct that the server and SQLAgent logs
in under ?
help ?
TIA

>--Original Message--
>What is the package trying to do when it fails? This can
happen because of
>privileges (or lack thereof) of the SQL Agent service
account that differ
>from the privileges used when running the package from
Enterprise Manager.
>--
>Bob
>Microsoft Consulting Services
>--
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Need to connect with trusted connection(not )
your account is a trusted connection therefore no requirement to have userid
and password
Dim IsTrusted ' IsTrusted is 0 by default
Dim oServer
Dim strServer
' Create DMO server object
Set oServer = CreateObject("SQLDMO.SQLServer")
' Use secure login and then login (trusted connection)
IsTrusted = 0
oServer.LoginSecure = True
' connect to the server requested
oServer.Connect (strServer)

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.
Vito,
Check if sqlagent is running.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.
|||I'm sure you have verified this, but have you checked to make sure that the job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure that the job in question has a yes in the enabled column.
|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.Vito,
Check if sqlagent is running.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.|||I'm sure you have verified this, but have you checked to make sure that the
job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure
that the job in question has a yes in the enabled column.|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.Vito,
Check if sqlagent is running.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.|||I'm sure you have verified this, but have you checked to make sure that the job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure that the job in question has a yes in the enabled column.|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Schedule a Job - Access denied

Greetings,
We have a NT4.0 SP6a server with SQLServer 7.0 SP3 installed. We have a job
that writes data to a text file. This job works fine either manually or
scheduled when writing to a local hard drive. However when writing to the
network the job will work when run manually but not when run scheduled.
I thought the problem has to do with the scheduler not having rights on the
network. The scheduler runs from the system account. When I tried to change
it to a network account I got this message, "Service Schedule could not be
configured to run under a shared process. If computer xxxx in not a Windows
2000 computer, service which run in a shared process must run under the
system account."
Error 1057: the account name is invalid or does not exist, or the password
is invalid for the account name specified.
Any idea how I can get this schedule job to write to the network?
Jim
Jim,
Which service did you change? You need to change the account of the
SQLServerAgent service to use a domain account that has rights to your
network resource.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602X.html
"Jim" wrote:

> Greetings,
> We have a NT4.0 SP6a server with SQLServer 7.0 SP3 installed. We have a job
> that writes data to a text file. This job works fine either manually or
> scheduled when writing to a local hard drive. However when writing to the
> network the job will work when run manually but not when run scheduled.
> I thought the problem has to do with the scheduler not having rights on the
> network. The scheduler runs from the system account. When I tried to change
> it to a network account I got this message, "Service Schedule could not be
> configured to run under a shared process. If computer xxxx in not a Windows
> 2000 computer, service which run in a shared process must run under the
> system account."
> Error 1057: the account name is invalid or does not exist, or the password
> is invalid for the account name specified.
> Any idea how I can get this schedule job to write to the network?
> Jim
>
>

Schedule a Job - Access denied

Greetings,
We have a NT4.0 SP6a server with SQLServer 7.0 SP3 installed. We have a job
that writes data to a text file. This job works fine either manually or
scheduled when writing to a local hard drive. However when writing to the
network the job will work when run manually but not when run scheduled.
I thought the problem has to do with the scheduler not having rights on the
network. The scheduler runs from the system account. When I tried to change
it to a network account I got this message, "Service Schedule could not be
configured to run under a shared process. If computer xxxx in not a Windows
2000 computer, service which run in a shared process must run under the
system account."
Error 1057: the account name is invalid or does not exist, or the password
is invalid for the account name specified.
Any idea how I can get this schedule job to write to the network?
JimJim,
Which service did you change? You need to change the account of the
SQLServerAgent service to use a domain account that has rights to your
network resource.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602_.html
"Jim" wrote:

> Greetings,
> We have a NT4.0 SP6a server with SQLServer 7.0 SP3 installed. We have a jo
b
> that writes data to a text file. This job works fine either manually or
> scheduled when writing to a local hard drive. However when writing to the
> network the job will work when run manually but not when run scheduled.
> I thought the problem has to do with the scheduler not having rights on th
e
> network. The scheduler runs from the system account. When I tried to chang
e
> it to a network account I got this message, "Service Schedule could not be
> configured to run under a shared process. If computer xxxx in not a Window
s
> 2000 computer, service which run in a shared process must run under the
> system account."
> Error 1057: the account name is invalid or does not exist, or the password
> is invalid for the account name specified.
> Any idea how I can get this schedule job to write to the network?
> Jim
>
>

Schedule a Job - Access denied

Greetings,
We have a NT4.0 SP6a server with SQLServer 7.0 SP3 installed. We have a job
that writes data to a text file. This job works fine either manually or
scheduled when writing to a local hard drive. However when writing to the
network the job will work when run manually but not when run scheduled.
I thought the problem has to do with the scheduler not having rights on the
network. The scheduler runs from the system account. When I tried to change
it to a network account I got this message, "Service Schedule could not be
configured to run under a shared process. If computer xxxx in not a Windows
2000 computer, service which run in a shared process must run under the
system account."
Error 1057: the account name is invalid or does not exist, or the password
is invalid for the account name specified.
Any idea how I can get this schedule job to write to the network?
JimJim,
Which service did you change? You need to change the account of the
SQLServerAgent service to use a domain account that has rights to your
network resource.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602­.html
"Jim" wrote:
> Greetings,
> We have a NT4.0 SP6a server with SQLServer 7.0 SP3 installed. We have a job
> that writes data to a text file. This job works fine either manually or
> scheduled when writing to a local hard drive. However when writing to the
> network the job will work when run manually but not when run scheduled.
> I thought the problem has to do with the scheduler not having rights on the
> network. The scheduler runs from the system account. When I tried to change
> it to a network account I got this message, "Service Schedule could not be
> configured to run under a shared process. If computer xxxx in not a Windows
> 2000 computer, service which run in a shared process must run under the
> system account."
> Error 1057: the account name is invalid or does not exist, or the password
> is invalid for the account name specified.
> Any idea how I can get this schedule job to write to the network?
> Jim
>
>