Next run date!

Hi,
Yesterday I changed a motherboard on my SQL server 7.0.
Today I noticed that jobs has not been started last night,
and I noticed that date is wrong on this machine,so I did
set the date and time and rebooted the machine, however
still can not see the next run date on scheduled job, even
if I create a new job, I can not see that. Does anyone
know how to fix this?
Thanks in advance-Rob
Hi Rob,
I learned the Job of SQL Server 7.0 did not start after changing the
motherboard and you cannot see the value of "Next run date" property of the
job. As far as I know, after changing the motherboard of the machine,
generally, the old operation system will crash. Do you mean your old
operation system is still available and there is not any problem?
According to your description, it seems all the jobs on your problematic
machine have this problem. If I have misunderstood, please feel free to let
me know. Have you started the SQL Server agent? If the problem still
occurred after starting SQL Server agent, what's the message in the Next
Run Date field of the problematic job?
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
|||Hi Rob,
How is the issue going on your side? Do you mean that the "Next Run Date"
column shows "(Date and Time are not available)" value? Even for a newly
created job although it has a valid schedule?
1. Please check again to see if the SQL Server Agent Service is started and
the jobs are enabled.
Right click on one of the jobs -> properties -> schedules tab -> make sure
there is a schedule set up for this job.
If so -> choose the schedule -> edit -> make sure the schedule is enabled
(checkbox is checked)
If not, check it and click ok and apply.
Now, right click on "Jobs" under SQL Server Agent and choose refresh. Check
if the next run date column shows any values. If so, please check each and
every single job to check if the schedule has been enabled.
2. If it still does not help, check in the MSDB database to see if you can
see the date but not in the GUI? Try the following SQL statement.
Select schedule_id, name, next_run_date, next_run_time from sysjobschedules
3. If it also does not show up in MSDB database, please try to run DBCC
CHECKDB against the MSDB database. Also, please enable and provide the SQL
Server Agent log.
For more information regarding SQL Server Agent log, please see the
following article on SQL Server Books Online.
Topic: "SQL Server Agent Properties (General Tab)"
4. If the date shows correctly in the MSDB database, check if an end date
has been specified for the job schedule and if it is already past the end
date?
5. Please run sp_help_job against the jobs to see if the next_run_date and
next_run_time shows correctly?
sp_help_job @.job_name = '<job_name>'
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Next run date!

Hi,
Yesterday I changed a motherboard on my SQL server 7.0.
Today I noticed that jobs has not been started last night,
and I noticed that date is wrong on this machine,so I did
set the date and time and rebooted the machine, however
still can not see the next run date on scheduled job, even
if I create a new job, I can not see that. Does anyone
know how to fix this?
Thanks in advance-RobHi Rob,
I learned the Job of SQL Server 7.0 did not start after changing the
motherboard and you cannot see the value of "Next run date" property of the
job. As far as I know, after changing the motherboard of the machine,
generally, the old operation system will crash. Do you mean your old
operation system is still available and there is not any problem?
According to your description, it seems all the jobs on your problematic
machine have this problem. If I have misunderstood, please feel free to let
me know. Have you started the SQL Server agent? If the problem still
occurred after starting SQL Server agent, what's the message in the Next
Run Date field of the problematic job?
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Rob,
How is the issue going on your side? Do you mean that the "Next Run Date"
column shows "(Date and Time are not available)" value? Even for a newly
created job although it has a valid schedule?
1. Please check again to see if the SQL Server Agent Service is started and
the jobs are enabled.
Right click on one of the jobs -> properties -> schedules tab -> make sure
there is a schedule set up for this job.
If so -> choose the schedule -> edit -> make sure the schedule is enabled
(checkbox is checked)
If not, check it and click ok and apply.
Now, right click on "Jobs" under SQL Server Agent and choose refresh. Check
if the next run date column shows any values. If so, please check each and
every single job to check if the schedule has been enabled.
2. If it still does not help, check in the MSDB database to see if you can
see the date but not in the GUI? Try the following SQL statement.
Select schedule_id, name, next_run_date, next_run_time from sysjobschedules
3. If it also does not show up in MSDB database, please try to run DBCC
CHECKDB against the MSDB database. Also, please enable and provide the SQL
Server Agent log.
For more information regarding SQL Server Agent log, please see the
following article on SQL Server Books Online.
Topic: "SQL Server Agent Properties (General Tab)"
4. If the date shows correctly in the MSDB database, check if an end date
has been specified for the job schedule and if it is already past the end
date?
5. Please run sp_help_job against the jobs to see if the next_run_date and
next_run_time shows correctly?
sp_help_job @.job_name = '<job_name>'
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

newsgroup sqlserver.msde , but no sqlserver.sqlexpress?

Am I looking in the wrong newsgroups, there is msde newsgroup, but I cannot
find a sqlexpress . Should I post questions about sqlexpress in the msde
group or where?
Jan D''Hondt
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
SQL database and .NET solutions
hi Jan,
Jan D''Hondt wrote:
> Am I looking in the wrong newsgroups, there is msde newsgroup, but I
> cannot find a sqlexpress . Should I post questions about sqlexpress
> in the msde group or where?
http://forums.microsoft.com/msdn/def...id=19&siteid=1
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea, Thank you for your help.
One has to wonder : what is the distinction between forums and newsgroups?
does it depend on the season? Are forums more fashionable than newsgroup?
Where are my pills?!?
Jan D''Hondt
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
SQL database and .NET solutions
"Andrea Montanari" wrote:

> hi Jan,
> Jan D''Hondt wrote:
> http://forums.microsoft.com/msdn/def...id=19&siteid=1
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Hi Jan,
go for that.
HTH, jens Suessmeyer.
|||On Wed, 16 Nov 2005 03:20:02 -0800, Jan D''Hondt wrote:

>Am I looking in the wrong newsgroups, there is msde newsgroup, but I cannot
>find a sqlexpress . Should I post questions about sqlexpress in the msde
>group or where?
Hi Jan,
I expect MS to open some new groups for the new features of SQL Server
2005 in the weeks to come; until they do, just pick the group that suits
the question best.
SQLExpress questions are fine here. They can also be posted in .server
or .programming.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||hi Jan,
Jan D''Hondt wrote:
> Andrea, Thank you for your help.
> One has to wonder : what is the distinction between forums and
> newsgroups? does it depend on the season? Are forums more fashionable
> than newsgroup?
Hugo already answered... Microsoft is quiet deprecating NG in favour of it's
own forum, but I do think they will add new SQL Server 2005 ng as well...
I've heard something about SQLExpress ng name, as someone suggested not to
name it "Express" in order to avoid user's confusion about "Express answers"
ROTFL
just a side note... I'd post SQLExpress questions on non MSDE ngs as it seem
Microsoft employees do not attend this one very much, so Setup problems and
the like are not very much probably answered..

> Where are my pills?!?
and where are mine? :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Newbie: Modifying table = wrong data in view?

Hi there,

Completely new to the world of databases. I'm a designer who works primarily in Flash. In any case, I'm trying to manage an application that uses MS SQL and learn about the wonderful world of databases.

Ok, I modified a table (e.g. I added a column called "Rate") that had associated views (created by another developer). Noticed that my application went a little wonky as some of my variables within my app took on the value of the data in the "Rate" column. I checked one of the views and noticed that a column within the view (e.g. TutorID) was assuming the values in the "Rate" column. Note: The column TutorID had been blank before the change to the table. I'm completely lost as to why this is happening. Do I need to rebuild the view? Can I just reset the original view?

Thanks.

Oh yeah, I'm using SQL4X Manager J from Mac Guru (if that helps).Scott, where are you? This is a prime example of what you were talking about at the bar, remember?|||Hey RD STEP BACK! nothing to see here....
Novian,
give us some DDL on your view and your table

DDL(object definitions) = a list of all of the cols in the view and in the underlying table

Perform the following steps:

Execute sp_helptext against the view to copy it's code.
Execute sp_depends against your view to obtain the name of the tables that the view depends on
right click your table in the object browser in the query analyzer and select "script object to new window as create"
copy the table script and the view code and reply here and paste them in here and we'll hook you up.

if you dont know how to run any of these commands, type them in the query analyzer and then select them and press SHIFT+F1 on your keyboard. Books Online will open to the helpfile for the appropriate procedure|||Hey guys,

Thanks for your help. Here's the info:

Results of sp_texthelp:

Text
CREATE VIEW dbo.GetUsers
AS
SELECT dbo.getUsersAndTutors.*,dbo.Students.StudentsID AS StudentID
FROM dbo.getUsersAndTutors LEFT OUTER JOIN
dbo.Students ON dbo.getUsersAndTutors.UID = dbo.Students.UID

Results of sp_depends:

dbo.getUsersAndTutors

Unfortunately, I can't seem to make the "script object to new window as create" work. I can't right click since I'm on a Mac. Any suggestions?

Thanks.|||For starters, get rid of SELECT *

On a MAC?|||Hi Brett,

Yeah, I'm using a db management software for the Mac. As such, "right-click" doesn't exist.

What do you mean by "get rid of Select *" ?

I know I can type this into the query analyzer and add the name of a table in order to see the table but I'm not sure how this fits in with what Ruprect has asked me to do.

Thanks.|||Okay, doing a little reading and I "think" I know what's going on...

As far as I understand, you can use shortcuts to insert data into tables. If you make a change to the table, you could run into problems if your values don't match up with the new table.

With that being said, I'm wondering if my 'view' which depends on the table that I changed is accepting data into the wrong field because the original table was created using a shortcut?

I guess the question still remains...how do I see the script that describes how my table was created? More specifically, how do I do this with a Mac-based MS SQL manager?

One last question: Is there a query that will allow me to see this script?|||Hey Ruprect,

Figured out that command. Here's what I got...

CREATE TABLE [dbo].[Users] (
[UID] int IDENTITY(1,1) NOT NULL,
[Firstname] nvarchar(255) NOT NULL,
[Lastname] nvarchar(255) NOT NULL,
[Nickname] nvarchar(50) NOT NULL,
[Password] nvarchar(50) NOT NULL,
[Gender] int NULL DEFAULT (0),
[EmailAddr] nvarchar(255) NOT NULL,
[City] nvarchar(255) NULL,
[ProvID] int NULL DEFAULT (0),
[CurrentSecurityLevel] int NULL DEFAULT (0),
[DesiredSecurityLevel] int NULL DEFAULT (0),
[ATID] int NULL DEFAULT (0),
[AFID] int NULL DEFAULT (0),
[SystemStatus] int NULL DEFAULT (0),
[isOnline] bit NOT NULL DEFAULT (0),
[isAvailISM] bit NOT NULL DEFAULT (0),
[UserInfo] ntext NULL,
[DOB] datetime NULL,
[RegistrationDate] datetime NOT NULL,
[LastLoginDate] datetime NULL,
[stat_TimesLoggedin] int NOT NULL DEFAULT (0),
[stat_ISMRecvBytes] int NULL DEFAULT (0),
[stat_ISMSentBytes] int NULL DEFAULT (0),
[stat_Apptsmade] int NULL DEFAULT (0),
[stat_MsgPosted] int NULL DEFAULT (0),
[TutorRate] nvarchar(18) NULL,
CONSTRAINT [aaaaaUsers_PK] PRIMARY KEY([UID])
)
GO
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [Users_FK05]
FOREIGN KEY([CurrentSecurityLevel])
REFERENCES [dbo].[Type_SecurityLevel]([SecurityLevel])
GO
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [Users_FK03]
FOREIGN KEY([ProvID])
REFERENCES [dbo].[Type_Province]([ProvID])
GO
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [Users_FK01]
FOREIGN KEY([ATID])
REFERENCES [dbo].[Type_Avatar]([ATID])
GO
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [Users_FK04]
FOREIGN KEY([DesiredSecurityLevel])
REFERENCES [dbo].[Type_SecurityLevel]([SecurityLevel])
GO
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [Users_FK00]
FOREIGN KEY([AFID])
REFERENCES [dbo].[Type_Affiliation]([AFID])
GO
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [Users_FK02]
FOREIGN KEY([Gender])
REFERENCES [dbo].[Type_Gender]([GID])
GO

Thanks, again.