Refresh page when database data is update

Hi All,

Is it possible to refresh the web page when certain table data is updated? And I cannot use the auto-refresh feature. Thank you very much.

Not easily. I imagine you could hobble something together with AJAX, but it would likely be fragile and not easy to maintain.

Refresh Execution of last run status

Hi,
I have a lot of jobs that was schedule in SQL Server Agent and since
2008-03-13, the status won't be update. But, i know that the job still
running well. But the status of the next run date was OK.
I have search on the web and i don't see anything that can help me.
SQL2000 Standard Edition (two instance) (SP4)
Windows 2003 Server
You have no error messages in the sql server or sql server agent log file?
Does the sql server agent service account have sysadmin rights?
Ola Hallengren
http://ola.hallengren.com
"inf0m286" wrote:

> Hi,
> I have a lot of jobs that was schedule in SQL Server Agent and since
> 2008-03-13, the status won't be update. But, i know that the job still
> running well. But the status of the next run date was OK.
> I have search on the web and i don't see anything that can help me.
>
> SQL2000 Standard Edition (two instance) (SP4)
> Windows 2003 Server
>
>
>
|||Hi Ola,
I see no error in the server and agent log file. But, there is something
strange. At each night, an automated backup is schedule and i stop/start sql
server during that task. Normally, it create a new SQL log file and it's not
doing that since 03/17 .
For the account that own SQL Server and Agent, it is the local system
account (in the definition on these services), so i think it has sysadmin
rights .
Thanks
"Ola Hallengren" wrote:
[vbcol=seagreen]
> You have no error messages in the sql server or sql server agent log file?
> Does the sql server agent service account have sysadmin rights?
> Ola Hallengren
> http://ola.hallengren.com
>
> "inf0m286" wrote:
|||>At each night, an automated backup is schedule and i stop/start sql server
during that task.
Could you give me some more information about how this is working. Is this a
sql server agent job?
Could you also give me some background for this backup strategy. In sql
server it is possible to backup a database with the BACKUP DATABASE command
while it is online.

>I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
What if you just create a simple sql server agent tsql job and execute that?
/Ola
"inf0m286" wrote:
[vbcol=seagreen]
> Hi Ola,
> I see no error in the server and agent log file. But, there is something
> strange. At each night, an automated backup is schedule and i stop/start sql
> server during that task. Normally, it create a new SQL log file and it's not
> doing that since 03/17 .
> For the account that own SQL Server and Agent, it is the local system
> account (in the definition on these services), so i think it has sysadmin
> rights .
> Thanks
>
> "Ola Hallengren" wrote:
|||A job for the tivoli server is scheduled and a we can run a pre-backup and
post-backup set. In the pre-backup step, a batch file is running In that
batch file, some services (SQL Server and SQL Server agent) is stopped (by
the dos command net stop). After that, the backup was taken and the services
is restarted.
I can take a backup while the database is online. i have make a tets with
SQL Query Analyzer.
Thanks.
André
"Ola Hallengren" wrote:
[vbcol=seagreen]
> during that task.
> Could you give me some more information about how this is working. Is this a
> sql server agent job?
> Could you also give me some background for this backup strategy. In sql
> server it is possible to backup a database with the BACKUP DATABASE command
> while it is online.
>
> What if you just create a simple sql server agent tsql job and execute that?
> /Ola
>
> "inf0m286" wrote:
|||I think that you should edit this batch file so that you don't stop and start
the sql server and sql server agent services.
Instead you should add some sqlcmd commands to the batch file that performs
that sql backups.
sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
= 'C:\master.bak'" -b
If you would like to have a more dynamic solution you could use a solution
that I have made for this.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"inf0m286" wrote:
[vbcol=seagreen]
> A job for the tivoli server is scheduled and a we can run a pre-backup and
> post-backup set. In the pre-backup step, a batch file is running In that
> batch file, some services (SQL Server and SQL Server agent) is stopped (by
> the dos command net stop). After that, the backup was taken and the services
> is restarted.
> I can take a backup while the database is online. i have make a tets with
> SQL Query Analyzer.
>
> Thanks.
> André
>
>
> "Ola Hallengren" wrote:
|||Hi Ola,
I know that i can take a backup online of each database and take these
databases for the backup. But, some of the jobs that was not update are the
maintenance plan that was created by the Database Maintenance plan wizard.And
that these jobs was running well before 2008-03-13 and also some job that we
created. The data
The only thing that was made on the server is the add of another instance of
SQL. That installation was made in mid-february and nothing was wrong with
that. The problem is coming up when i detached one database of the first
instance and move it on the second one. And i created a maintenance plan for
the new instance and the status is OK
It's really a strange error.
Thanks.
"Ola Hallengren" wrote:
[vbcol=seagreen]
> I think that you should edit this batch file so that you don't stop and start
> the sql server and sql server agent services.
> Instead you should add some sqlcmd commands to the batch file that performs
> that sql backups.
> sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> = 'C:\master.bak'" -b
> If you would like to have a more dynamic solution you could use a solution
> that I have made for this.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "inf0m286" wrote:
|||Did you do this test on the instance where you have the problem?
What if you just create a simple sql server agent tsql job and execute that?
/Ola
"inf0m286" wrote:
[vbcol=seagreen]
> Hi Ola,
> I know that i can take a backup online of each database and take these
> databases for the backup. But, some of the jobs that was not update are the
> maintenance plan that was created by the Database Maintenance plan wizard.And
> that these jobs was running well before 2008-03-13 and also some job that we
> created. The data
> The only thing that was made on the server is the add of another instance of
> SQL. That installation was made in mid-february and nothing was wrong with
> that. The problem is coming up when i detached one database of the first
> instance and move it on the second one. And i created a maintenance plan for
> the new instance and the status is OK
> It's really a strange error.
> Thanks.
>
> "Ola Hallengren" wrote:

Refresh Execution of last run status

Hi,
I have a lot of jobs that was schedule in SQL Server Agent and since
2008-03-13, the status won't be update. But, i know that the job still
running well. But the status of the next run date was OK.
I have search on the web and i don't see anything that can help me.
SQL2000 Standard Edition (two instance) (SP4)
Windows 2003 ServerYou have no error messages in the sql server or sql server agent log file?
Does the sql server agent service account have sysadmin rights?
Ola Hallengren
http://ola.hallengren.com
"inf0m286" wrote:
> Hi,
> I have a lot of jobs that was schedule in SQL Server Agent and since
> 2008-03-13, the status won't be update. But, i know that the job still
> running well. But the status of the next run date was OK.
> I have search on the web and i don't see anything that can help me.
>
> SQL2000 Standard Edition (two instance) (SP4)
> Windows 2003 Server
>
>
>|||Hi Ola,
I see no error in the server and agent log file. But, there is something
strange. At each night, an automated backup is schedule and i stop/start sql
server during that task. Normally, it create a new SQL log file and it's not
doing that since 03/17 .
For the account that own SQL Server and Agent, it is the local system
account (in the definition on these services), so i think it has sysadmin
rights .
Thanks
"Ola Hallengren" wrote:
> You have no error messages in the sql server or sql server agent log file?
> Does the sql server agent service account have sysadmin rights?
> Ola Hallengren
> http://ola.hallengren.com
>
> "inf0m286" wrote:
> > Hi,
> >
> > I have a lot of jobs that was schedule in SQL Server Agent and since
> > 2008-03-13, the status won't be update. But, i know that the job still
> > running well. But the status of the next run date was OK.
> >
> > I have search on the web and i don't see anything that can help me.
> >
> >
> > SQL2000 Standard Edition (two instance) (SP4)
> > Windows 2003 Server
> >
> >
> >
> >
> >|||>At each night, an automated backup is schedule and i stop/start sql server
during that task.
Could you give me some more information about how this is working. Is this a
sql server agent job?
Could you also give me some background for this backup strategy. In sql
server it is possible to backup a database with the BACKUP DATABASE command
while it is online.
>I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
What if you just create a simple sql server agent tsql job and execute that?
/Ola
"inf0m286" wrote:
> Hi Ola,
> I see no error in the server and agent log file. But, there is something
> strange. At each night, an automated backup is schedule and i stop/start sql
> server during that task. Normally, it create a new SQL log file and it's not
> doing that since 03/17 .
> For the account that own SQL Server and Agent, it is the local system
> account (in the definition on these services), so i think it has sysadmin
> rights .
> Thanks
>
> "Ola Hallengren" wrote:
> > You have no error messages in the sql server or sql server agent log file?
> >
> > Does the sql server agent service account have sysadmin rights?
> >
> > Ola Hallengren
> > http://ola.hallengren.com
> >
> >
> >
> > "inf0m286" wrote:
> >
> > > Hi,
> > >
> > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > 2008-03-13, the status won't be update. But, i know that the job still
> > > running well. But the status of the next run date was OK.
> > >
> > > I have search on the web and i don't see anything that can help me.
> > >
> > >
> > > SQL2000 Standard Edition (two instance) (SP4)
> > > Windows 2003 Server
> > >
> > >
> > >
> > >
> > >|||A job for the tivoli server is scheduled and a we can run a pre-backup and
post-backup set. In the pre-backup step, a batch file is running In that
batch file, some services (SQL Server and SQL Server agent) is stopped (by
the dos command net stop). After that, the backup was taken and the services
is restarted.
I can take a backup while the database is online. i have make a tets with
SQL Query Analyzer.
Thanks.
André
"Ola Hallengren" wrote:
> >At each night, an automated backup is schedule and i stop/start sql server
> during that task.
> Could you give me some more information about how this is working. Is this a
> sql server agent job?
> Could you also give me some background for this backup strategy. In sql
> server it is possible to backup a database with the BACKUP DATABASE command
> while it is online.
> >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> What if you just create a simple sql server agent tsql job and execute that?
> /Ola
>
> "inf0m286" wrote:
> > Hi Ola,
> >
> > I see no error in the server and agent log file. But, there is something
> > strange. At each night, an automated backup is schedule and i stop/start sql
> > server during that task. Normally, it create a new SQL log file and it's not
> > doing that since 03/17 .
> >
> > For the account that own SQL Server and Agent, it is the local system
> > account (in the definition on these services), so i think it has sysadmin
> > rights .
> >
> > Thanks
> >
> >
> > "Ola Hallengren" wrote:
> >
> > > You have no error messages in the sql server or sql server agent log file?
> > >
> > > Does the sql server agent service account have sysadmin rights?
> > >
> > > Ola Hallengren
> > > http://ola.hallengren.com
> > >
> > >
> > >
> > > "inf0m286" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > running well. But the status of the next run date was OK.
> > > >
> > > > I have search on the web and i don't see anything that can help me.
> > > >
> > > >
> > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > Windows 2003 Server
> > > >
> > > >
> > > >
> > > >
> > > >|||I think that you should edit this batch file so that you don't stop and start
the sql server and sql server agent services.
Instead you should add some sqlcmd commands to the batch file that performs
that sql backups.
sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
= 'C:\master.bak'" -b
If you would like to have a more dynamic solution you could use a solution
that I have made for this.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"inf0m286" wrote:
> A job for the tivoli server is scheduled and a we can run a pre-backup and
> post-backup set. In the pre-backup step, a batch file is running In that
> batch file, some services (SQL Server and SQL Server agent) is stopped (by
> the dos command net stop). After that, the backup was taken and the services
> is restarted.
> I can take a backup while the database is online. i have make a tets with
> SQL Query Analyzer.
>
> Thanks.
> André
>
>
> "Ola Hallengren" wrote:
> > >At each night, an automated backup is schedule and i stop/start sql server
> > during that task.
> >
> > Could you give me some more information about how this is working. Is this a
> > sql server agent job?
> >
> > Could you also give me some background for this backup strategy. In sql
> > server it is possible to backup a database with the BACKUP DATABASE command
> > while it is online.
> >
> > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> >
> > What if you just create a simple sql server agent tsql job and execute that?
> >
> > /Ola
> >
> >
> >
> > "inf0m286" wrote:
> >
> > > Hi Ola,
> > >
> > > I see no error in the server and agent log file. But, there is something
> > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > server during that task. Normally, it create a new SQL log file and it's not
> > > doing that since 03/17 .
> > >
> > > For the account that own SQL Server and Agent, it is the local system
> > > account (in the definition on these services), so i think it has sysadmin
> > > rights .
> > >
> > > Thanks
> > >
> > >
> > > "Ola Hallengren" wrote:
> > >
> > > > You have no error messages in the sql server or sql server agent log file?
> > > >
> > > > Does the sql server agent service account have sysadmin rights?
> > > >
> > > > Ola Hallengren
> > > > http://ola.hallengren.com
> > > >
> > > >
> > > >
> > > > "inf0m286" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > running well. But the status of the next run date was OK.
> > > > >
> > > > > I have search on the web and i don't see anything that can help me.
> > > > >
> > > > >
> > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > Windows 2003 Server
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >|||Hi Ola,
I know that i can take a backup online of each database and take these
databases for the backup. But, some of the jobs that was not update are the
maintenance plan that was created by the Database Maintenance plan wizard.And
that these jobs was running well before 2008-03-13 and also some job that we
created. The data
The only thing that was made on the server is the add of another instance of
SQL. That installation was made in mid-february and nothing was wrong with
that. The problem is coming up when i detached one database of the first
instance and move it on the second one. And i created a maintenance plan for
the new instance and the status is OK
It's really a strange error.
Thanks.
"Ola Hallengren" wrote:
> I think that you should edit this batch file so that you don't stop and start
> the sql server and sql server agent services.
> Instead you should add some sqlcmd commands to the batch file that performs
> that sql backups.
> sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> = 'C:\master.bak'" -b
> If you would like to have a more dynamic solution you could use a solution
> that I have made for this.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "inf0m286" wrote:
> > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > post-backup set. In the pre-backup step, a batch file is running In that
> > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > the dos command net stop). After that, the backup was taken and the services
> > is restarted.
> >
> > I can take a backup while the database is online. i have make a tets with
> > SQL Query Analyzer.
> >
> >
> > Thanks.
> >
> > André
> >
> >
> >
> >
> >
> > "Ola Hallengren" wrote:
> >
> > > >At each night, an automated backup is schedule and i stop/start sql server
> > > during that task.
> > >
> > > Could you give me some more information about how this is working. Is this a
> > > sql server agent job?
> > >
> > > Could you also give me some background for this backup strategy. In sql
> > > server it is possible to backup a database with the BACKUP DATABASE command
> > > while it is online.
> > >
> > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > >
> > > What if you just create a simple sql server agent tsql job and execute that?
> > >
> > > /Ola
> > >
> > >
> > >
> > > "inf0m286" wrote:
> > >
> > > > Hi Ola,
> > > >
> > > > I see no error in the server and agent log file. But, there is something
> > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > doing that since 03/17 .
> > > >
> > > > For the account that own SQL Server and Agent, it is the local system
> > > > account (in the definition on these services), so i think it has sysadmin
> > > > rights .
> > > >
> > > > Thanks
> > > >
> > > >
> > > > "Ola Hallengren" wrote:
> > > >
> > > > > You have no error messages in the sql server or sql server agent log file?
> > > > >
> > > > > Does the sql server agent service account have sysadmin rights?
> > > > >
> > > > > Ola Hallengren
> > > > > http://ola.hallengren.com
> > > > >
> > > > >
> > > > >
> > > > > "inf0m286" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > running well. But the status of the next run date was OK.
> > > > > >
> > > > > > I have search on the web and i don't see anything that can help me.
> > > > > >
> > > > > >
> > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > Windows 2003 Server
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >|||Did you do this test on the instance where you have the problem?
What if you just create a simple sql server agent tsql job and execute that?
/Ola
"inf0m286" wrote:
> Hi Ola,
> I know that i can take a backup online of each database and take these
> databases for the backup. But, some of the jobs that was not update are the
> maintenance plan that was created by the Database Maintenance plan wizard.And
> that these jobs was running well before 2008-03-13 and also some job that we
> created. The data
> The only thing that was made on the server is the add of another instance of
> SQL. That installation was made in mid-february and nothing was wrong with
> that. The problem is coming up when i detached one database of the first
> instance and move it on the second one. And i created a maintenance plan for
> the new instance and the status is OK
> It's really a strange error.
> Thanks.
>
> "Ola Hallengren" wrote:
> > I think that you should edit this batch file so that you don't stop and start
> > the sql server and sql server agent services.
> >
> > Instead you should add some sqlcmd commands to the batch file that performs
> > that sql backups.
> >
> > sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> > = 'C:\master.bak'" -b
> >
> > If you would like to have a more dynamic solution you could use a solution
> > that I have made for this.
> > http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> >
> > Ola Hallengren
> > http://ola.hallengren.com
> >
> >
> >
> > "inf0m286" wrote:
> >
> > > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > > post-backup set. In the pre-backup step, a batch file is running In that
> > > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > > the dos command net stop). After that, the backup was taken and the services
> > > is restarted.
> > >
> > > I can take a backup while the database is online. i have make a tets with
> > > SQL Query Analyzer.
> > >
> > >
> > > Thanks.
> > >
> > > André
> > >
> > >
> > >
> > >
> > >
> > > "Ola Hallengren" wrote:
> > >
> > > > >At each night, an automated backup is schedule and i stop/start sql server
> > > > during that task.
> > > >
> > > > Could you give me some more information about how this is working. Is this a
> > > > sql server agent job?
> > > >
> > > > Could you also give me some background for this backup strategy. In sql
> > > > server it is possible to backup a database with the BACKUP DATABASE command
> > > > while it is online.
> > > >
> > > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > > >
> > > > What if you just create a simple sql server agent tsql job and execute that?
> > > >
> > > > /Ola
> > > >
> > > >
> > > >
> > > > "inf0m286" wrote:
> > > >
> > > > > Hi Ola,
> > > > >
> > > > > I see no error in the server and agent log file. But, there is something
> > > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > > doing that since 03/17 .
> > > > >
> > > > > For the account that own SQL Server and Agent, it is the local system
> > > > > account (in the definition on these services), so i think it has sysadmin
> > > > > rights .
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > > "Ola Hallengren" wrote:
> > > > >
> > > > > > You have no error messages in the sql server or sql server agent log file?
> > > > > >
> > > > > > Does the sql server agent service account have sysadmin rights?
> > > > > >
> > > > > > Ola Hallengren
> > > > > > http://ola.hallengren.com
> > > > > >
> > > > > >
> > > > > >
> > > > > > "inf0m286" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > > running well. But the status of the next run date was OK.
> > > > > > >
> > > > > > > I have search on the web and i don't see anything that can help me.
> > > > > > >
> > > > > > >
> > > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > > Windows 2003 Server
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >|||Hi Ola,
I created two simple job (one on each instance) that executedd a DOS command
and on the default instance, noting was updated and in the new instance, all
is right.
I also make a test on a virtual machine with 2 instances and i have the same
problem
Thanks
"Ola Hallengren" wrote:
> Did you do this test on the instance where you have the problem?
> What if you just create a simple sql server agent tsql job and execute that?
> /Ola
>
>
> "inf0m286" wrote:
> > Hi Ola,
> >
> > I know that i can take a backup online of each database and take these
> > databases for the backup. But, some of the jobs that was not update are the
> > maintenance plan that was created by the Database Maintenance plan wizard.And
> > that these jobs was running well before 2008-03-13 and also some job that we
> > created. The data
> >
> > The only thing that was made on the server is the add of another instance of
> > SQL. That installation was made in mid-february and nothing was wrong with
> > that. The problem is coming up when i detached one database of the first
> > instance and move it on the second one. And i created a maintenance plan for
> > the new instance and the status is OK
> >
> > It's really a strange error.
> >
> > Thanks.
> >
> >
> > "Ola Hallengren" wrote:
> >
> > > I think that you should edit this batch file so that you don't stop and start
> > > the sql server and sql server agent services.
> > >
> > > Instead you should add some sqlcmd commands to the batch file that performs
> > > that sql backups.
> > >
> > > sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> > > = 'C:\master.bak'" -b
> > >
> > > If you would like to have a more dynamic solution you could use a solution
> > > that I have made for this.
> > > http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> > >
> > > Ola Hallengren
> > > http://ola.hallengren.com
> > >
> > >
> > >
> > > "inf0m286" wrote:
> > >
> > > > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > > > post-backup set. In the pre-backup step, a batch file is running In that
> > > > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > > > the dos command net stop). After that, the backup was taken and the services
> > > > is restarted.
> > > >
> > > > I can take a backup while the database is online. i have make a tets with
> > > > SQL Query Analyzer.
> > > >
> > > >
> > > > Thanks.
> > > >
> > > > André
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Ola Hallengren" wrote:
> > > >
> > > > > >At each night, an automated backup is schedule and i stop/start sql server
> > > > > during that task.
> > > > >
> > > > > Could you give me some more information about how this is working. Is this a
> > > > > sql server agent job?
> > > > >
> > > > > Could you also give me some background for this backup strategy. In sql
> > > > > server it is possible to backup a database with the BACKUP DATABASE command
> > > > > while it is online.
> > > > >
> > > > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > > > >
> > > > > What if you just create a simple sql server agent tsql job and execute that?
> > > > >
> > > > > /Ola
> > > > >
> > > > >
> > > > >
> > > > > "inf0m286" wrote:
> > > > >
> > > > > > Hi Ola,
> > > > > >
> > > > > > I see no error in the server and agent log file. But, there is something
> > > > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > > > doing that since 03/17 .
> > > > > >
> > > > > > For the account that own SQL Server and Agent, it is the local system
> > > > > > account (in the definition on these services), so i think it has sysadmin
> > > > > > rights .
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > > > "Ola Hallengren" wrote:
> > > > > >
> > > > > > > You have no error messages in the sql server or sql server agent log file?
> > > > > > >
> > > > > > > Does the sql server agent service account have sysadmin rights?
> > > > > > >
> > > > > > > Ola Hallengren
> > > > > > > http://ola.hallengren.com
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "inf0m286" wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > > > running well. But the status of the next run date was OK.
> > > > > > > >
> > > > > > > > I have search on the web and i don't see anything that can help me.
> > > > > > > >
> > > > > > > >
> > > > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > > > Windows 2003 Server
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >|||I'm sorry, but I don't know how to solve this problem.
Ola Hallengren
http://ola.hallengren.com
"inf0m286" wrote:
> Hi Ola,
> I created two simple job (one on each instance) that executedd a DOS command
> and on the default instance, noting was updated and in the new instance, all
> is right.
> I also make a test on a virtual machine with 2 instances and i have the same
> problem
> Thanks
> "Ola Hallengren" wrote:
> > Did you do this test on the instance where you have the problem?
> >
> > What if you just create a simple sql server agent tsql job and execute that?
> >
> > /Ola
> >
> >
> >
> >
> > "inf0m286" wrote:
> >
> > > Hi Ola,
> > >
> > > I know that i can take a backup online of each database and take these
> > > databases for the backup. But, some of the jobs that was not update are the
> > > maintenance plan that was created by the Database Maintenance plan wizard.And
> > > that these jobs was running well before 2008-03-13 and also some job that we
> > > created. The data
> > >
> > > The only thing that was made on the server is the add of another instance of
> > > SQL. That installation was made in mid-february and nothing was wrong with
> > > that. The problem is coming up when i detached one database of the first
> > > instance and move it on the second one. And i created a maintenance plan for
> > > the new instance and the status is OK
> > >
> > > It's really a strange error.
> > >
> > > Thanks.
> > >
> > >
> > > "Ola Hallengren" wrote:
> > >
> > > > I think that you should edit this batch file so that you don't stop and start
> > > > the sql server and sql server agent services.
> > > >
> > > > Instead you should add some sqlcmd commands to the batch file that performs
> > > > that sql backups.
> > > >
> > > > sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> > > > = 'C:\master.bak'" -b
> > > >
> > > > If you would like to have a more dynamic solution you could use a solution
> > > > that I have made for this.
> > > > http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> > > >
> > > > Ola Hallengren
> > > > http://ola.hallengren.com
> > > >
> > > >
> > > >
> > > > "inf0m286" wrote:
> > > >
> > > > > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > > > > post-backup set. In the pre-backup step, a batch file is running In that
> > > > > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > > > > the dos command net stop). After that, the backup was taken and the services
> > > > > is restarted.
> > > > >
> > > > > I can take a backup while the database is online. i have make a tets with
> > > > > SQL Query Analyzer.
> > > > >
> > > > >
> > > > > Thanks.
> > > > >
> > > > > André
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Ola Hallengren" wrote:
> > > > >
> > > > > > >At each night, an automated backup is schedule and i stop/start sql server
> > > > > > during that task.
> > > > > >
> > > > > > Could you give me some more information about how this is working. Is this a
> > > > > > sql server agent job?
> > > > > >
> > > > > > Could you also give me some background for this backup strategy. In sql
> > > > > > server it is possible to backup a database with the BACKUP DATABASE command
> > > > > > while it is online.
> > > > > >
> > > > > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > > > > >
> > > > > > What if you just create a simple sql server agent tsql job and execute that?
> > > > > >
> > > > > > /Ola
> > > > > >
> > > > > >
> > > > > >
> > > > > > "inf0m286" wrote:
> > > > > >
> > > > > > > Hi Ola,
> > > > > > >
> > > > > > > I see no error in the server and agent log file. But, there is something
> > > > > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > > > > doing that since 03/17 .
> > > > > > >
> > > > > > > For the account that own SQL Server and Agent, it is the local system
> > > > > > > account (in the definition on these services), so i think it has sysadmin
> > > > > > > rights .
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > >
> > > > > > > "Ola Hallengren" wrote:
> > > > > > >
> > > > > > > > You have no error messages in the sql server or sql server agent log file?
> > > > > > > >
> > > > > > > > Does the sql server agent service account have sysadmin rights?
> > > > > > > >
> > > > > > > > Ola Hallengren
> > > > > > > > http://ola.hallengren.com
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "inf0m286" wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > > > > running well. But the status of the next run date was OK.
> > > > > > > > >
> > > > > > > > > I have search on the web and i don't see anything that can help me.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > > > > Windows 2003 Server
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >|||Hi Ola,
Thanks for your support. If someone else find a solution, would you like to
know it '
Bye.
André
"Ola Hallengren" wrote:
> I'm sorry, but I don't know how to solve this problem.
> Ola Hallengren
> http://ola.hallengren.com
>
> "inf0m286" wrote:
> > Hi Ola,
> >
> > I created two simple job (one on each instance) that executedd a DOS command
> > and on the default instance, noting was updated and in the new instance, all
> > is right.
> >
> > I also make a test on a virtual machine with 2 instances and i have the same
> > problem
> >
> > Thanks
> >
> > "Ola Hallengren" wrote:
> >
> > > Did you do this test on the instance where you have the problem?
> > >
> > > What if you just create a simple sql server agent tsql job and execute that?
> > >
> > > /Ola
> > >
> > >
> > >
> > >
> > > "inf0m286" wrote:
> > >
> > > > Hi Ola,
> > > >
> > > > I know that i can take a backup online of each database and take these
> > > > databases for the backup. But, some of the jobs that was not update are the
> > > > maintenance plan that was created by the Database Maintenance plan wizard.And
> > > > that these jobs was running well before 2008-03-13 and also some job that we
> > > > created. The data
> > > >
> > > > The only thing that was made on the server is the add of another instance of
> > > > SQL. That installation was made in mid-february and nothing was wrong with
> > > > that. The problem is coming up when i detached one database of the first
> > > > instance and move it on the second one. And i created a maintenance plan for
> > > > the new instance and the status is OK
> > > >
> > > > It's really a strange error.
> > > >
> > > > Thanks.
> > > >
> > > >
> > > > "Ola Hallengren" wrote:
> > > >
> > > > > I think that you should edit this batch file so that you don't stop and start
> > > > > the sql server and sql server agent services.
> > > > >
> > > > > Instead you should add some sqlcmd commands to the batch file that performs
> > > > > that sql backups.
> > > > >
> > > > > sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> > > > > = 'C:\master.bak'" -b
> > > > >
> > > > > If you would like to have a more dynamic solution you could use a solution
> > > > > that I have made for this.
> > > > > http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> > > > >
> > > > > Ola Hallengren
> > > > > http://ola.hallengren.com
> > > > >
> > > > >
> > > > >
> > > > > "inf0m286" wrote:
> > > > >
> > > > > > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > > > > > post-backup set. In the pre-backup step, a batch file is running In that
> > > > > > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > > > > > the dos command net stop). After that, the backup was taken and the services
> > > > > > is restarted.
> > > > > >
> > > > > > I can take a backup while the database is online. i have make a tets with
> > > > > > SQL Query Analyzer.
> > > > > >
> > > > > >
> > > > > > Thanks.
> > > > > >
> > > > > > André
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Ola Hallengren" wrote:
> > > > > >
> > > > > > > >At each night, an automated backup is schedule and i stop/start sql server
> > > > > > > during that task.
> > > > > > >
> > > > > > > Could you give me some more information about how this is working. Is this a
> > > > > > > sql server agent job?
> > > > > > >
> > > > > > > Could you also give me some background for this backup strategy. In sql
> > > > > > > server it is possible to backup a database with the BACKUP DATABASE command
> > > > > > > while it is online.
> > > > > > >
> > > > > > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > > > > > >
> > > > > > > What if you just create a simple sql server agent tsql job and execute that?
> > > > > > >
> > > > > > > /Ola
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "inf0m286" wrote:
> > > > > > >
> > > > > > > > Hi Ola,
> > > > > > > >
> > > > > > > > I see no error in the server and agent log file. But, there is something
> > > > > > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > > > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > > > > > doing that since 03/17 .
> > > > > > > >
> > > > > > > > For the account that own SQL Server and Agent, it is the local system
> > > > > > > > account (in the definition on these services), so i think it has sysadmin
> > > > > > > > rights .
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > > >
> > > > > > > > "Ola Hallengren" wrote:
> > > > > > > >
> > > > > > > > > You have no error messages in the sql server or sql server agent log file?
> > > > > > > > >
> > > > > > > > > Does the sql server agent service account have sysadmin rights?
> > > > > > > > >
> > > > > > > > > Ola Hallengren
> > > > > > > > > http://ola.hallengren.com
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "inf0m286" wrote:
> > > > > > > > >
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > > > > > running well. But the status of the next run date was OK.
> > > > > > > > > >
> > > > > > > > > > I have search on the web and i don't see anything that can help me.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > > > > > Windows 2003 Server
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >|||Sure. Just post it to this thread then. I have notification enabled.
Ola Hallengren
http://ola.hallengren.com
"inf0m286" wrote:
> Hi Ola,
> Thanks for your support. If someone else find a solution, would you like to
> know it '
> Bye.
> André
>
> "Ola Hallengren" wrote:
> > I'm sorry, but I don't know how to solve this problem.
> >
> > Ola Hallengren
> > http://ola.hallengren.com
> >
> >
> >
> > "inf0m286" wrote:
> >
> > > Hi Ola,
> > >
> > > I created two simple job (one on each instance) that executedd a DOS command
> > > and on the default instance, noting was updated and in the new instance, all
> > > is right.
> > >
> > > I also make a test on a virtual machine with 2 instances and i have the same
> > > problem
> > >
> > > Thanks
> > >
> > > "Ola Hallengren" wrote:
> > >
> > > > Did you do this test on the instance where you have the problem?
> > > >
> > > > What if you just create a simple sql server agent tsql job and execute that?
> > > >
> > > > /Ola
> > > >
> > > >
> > > >
> > > >
> > > > "inf0m286" wrote:
> > > >
> > > > > Hi Ola,
> > > > >
> > > > > I know that i can take a backup online of each database and take these
> > > > > databases for the backup. But, some of the jobs that was not update are the
> > > > > maintenance plan that was created by the Database Maintenance plan wizard.And
> > > > > that these jobs was running well before 2008-03-13 and also some job that we
> > > > > created. The data
> > > > >
> > > > > The only thing that was made on the server is the add of another instance of
> > > > > SQL. That installation was made in mid-february and nothing was wrong with
> > > > > that. The problem is coming up when i detached one database of the first
> > > > > instance and move it on the second one. And i created a maintenance plan for
> > > > > the new instance and the status is OK
> > > > >
> > > > > It's really a strange error.
> > > > >
> > > > > Thanks.
> > > > >
> > > > >
> > > > > "Ola Hallengren" wrote:
> > > > >
> > > > > > I think that you should edit this batch file so that you don't stop and start
> > > > > > the sql server and sql server agent services.
> > > > > >
> > > > > > Instead you should add some sqlcmd commands to the batch file that performs
> > > > > > that sql backups.
> > > > > >
> > > > > > sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> > > > > > = 'C:\master.bak'" -b
> > > > > >
> > > > > > If you would like to have a more dynamic solution you could use a solution
> > > > > > that I have made for this.
> > > > > > http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> > > > > >
> > > > > > Ola Hallengren
> > > > > > http://ola.hallengren.com
> > > > > >
> > > > > >
> > > > > >
> > > > > > "inf0m286" wrote:
> > > > > >
> > > > > > > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > > > > > > post-backup set. In the pre-backup step, a batch file is running In that
> > > > > > > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > > > > > > the dos command net stop). After that, the backup was taken and the services
> > > > > > > is restarted.
> > > > > > >
> > > > > > > I can take a backup while the database is online. i have make a tets with
> > > > > > > SQL Query Analyzer.
> > > > > > >
> > > > > > >
> > > > > > > Thanks.
> > > > > > >
> > > > > > > André
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Ola Hallengren" wrote:
> > > > > > >
> > > > > > > > >At each night, an automated backup is schedule and i stop/start sql server
> > > > > > > > during that task.
> > > > > > > >
> > > > > > > > Could you give me some more information about how this is working. Is this a
> > > > > > > > sql server agent job?
> > > > > > > >
> > > > > > > > Could you also give me some background for this backup strategy. In sql
> > > > > > > > server it is possible to backup a database with the BACKUP DATABASE command
> > > > > > > > while it is online.
> > > > > > > >
> > > > > > > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > > > > > > >
> > > > > > > > What if you just create a simple sql server agent tsql job and execute that?
> > > > > > > >
> > > > > > > > /Ola
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "inf0m286" wrote:
> > > > > > > >
> > > > > > > > > Hi Ola,
> > > > > > > > >
> > > > > > > > > I see no error in the server and agent log file. But, there is something
> > > > > > > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > > > > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > > > > > > doing that since 03/17 .
> > > > > > > > >
> > > > > > > > > For the account that own SQL Server and Agent, it is the local system
> > > > > > > > > account (in the definition on these services), so i think it has sysadmin
> > > > > > > > > rights .
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Ola Hallengren" wrote:
> > > > > > > > >
> > > > > > > > > > You have no error messages in the sql server or sql server agent log file?
> > > > > > > > > >
> > > > > > > > > > Does the sql server agent service account have sysadmin rights?
> > > > > > > > > >
> > > > > > > > > > Ola Hallengren
> > > > > > > > > > http://ola.hallengren.com
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "inf0m286" wrote:
> > > > > > > > > >
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > > > > > > running well. But the status of the next run date was OK.
> > > > > > > > > > >
> > > > > > > > > > > I have search on the web and i don't see anything that can help me.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > > > > > > Windows 2003 Server
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >|||Hi Ola,
Finally, there is a solution. Someone find that there is too much entry in
the alias tab in the SQL Server Network utility. So i delete all these alias,
create only the one i need and the problem was gone.
Bye.
André.
"Ola Hallengren" wrote:
> Sure. Just post it to this thread then. I have notification enabled.
> Ola Hallengren
> http://ola.hallengren.com
>
>
> "inf0m286" wrote:
> > Hi Ola,
> >
> > Thanks for your support. If someone else find a solution, would you like to
> > know it '
> >
> > Bye.
> >
> > André
> >
> >
> >
> > "Ola Hallengren" wrote:
> >
> > > I'm sorry, but I don't know how to solve this problem.
> > >
> > > Ola Hallengren
> > > http://ola.hallengren.com
> > >
> > >
> > >
> > > "inf0m286" wrote:
> > >
> > > > Hi Ola,
> > > >
> > > > I created two simple job (one on each instance) that executedd a DOS command
> > > > and on the default instance, noting was updated and in the new instance, all
> > > > is right.
> > > >
> > > > I also make a test on a virtual machine with 2 instances and i have the same
> > > > problem
> > > >
> > > > Thanks
> > > >
> > > > "Ola Hallengren" wrote:
> > > >
> > > > > Did you do this test on the instance where you have the problem?
> > > > >
> > > > > What if you just create a simple sql server agent tsql job and execute that?
> > > > >
> > > > > /Ola
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "inf0m286" wrote:
> > > > >
> > > > > > Hi Ola,
> > > > > >
> > > > > > I know that i can take a backup online of each database and take these
> > > > > > databases for the backup. But, some of the jobs that was not update are the
> > > > > > maintenance plan that was created by the Database Maintenance plan wizard.And
> > > > > > that these jobs was running well before 2008-03-13 and also some job that we
> > > > > > created. The data
> > > > > >
> > > > > > The only thing that was made on the server is the add of another instance of
> > > > > > SQL. That installation was made in mid-february and nothing was wrong with
> > > > > > that. The problem is coming up when i detached one database of the first
> > > > > > instance and move it on the second one. And i created a maintenance plan for
> > > > > > the new instance and the status is OK
> > > > > >
> > > > > > It's really a strange error.
> > > > > >
> > > > > > Thanks.
> > > > > >
> > > > > >
> > > > > > "Ola Hallengren" wrote:
> > > > > >
> > > > > > > I think that you should edit this batch file so that you don't stop and start
> > > > > > > the sql server and sql server agent services.
> > > > > > >
> > > > > > > Instead you should add some sqlcmd commands to the batch file that performs
> > > > > > > that sql backups.
> > > > > > >
> > > > > > > sqlcmd -E -S Server1\Instance1 -d master -Q "BACKUP DATABASE master TO DISK
> > > > > > > = 'C:\master.bak'" -b
> > > > > > >
> > > > > > > If you would like to have a more dynamic solution you could use a solution
> > > > > > > that I have made for this.
> > > > > > > http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> > > > > > >
> > > > > > > Ola Hallengren
> > > > > > > http://ola.hallengren.com
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "inf0m286" wrote:
> > > > > > >
> > > > > > > > A job for the tivoli server is scheduled and a we can run a pre-backup and
> > > > > > > > post-backup set. In the pre-backup step, a batch file is running In that
> > > > > > > > batch file, some services (SQL Server and SQL Server agent) is stopped (by
> > > > > > > > the dos command net stop). After that, the backup was taken and the services
> > > > > > > > is restarted.
> > > > > > > >
> > > > > > > > I can take a backup while the database is online. i have make a tets with
> > > > > > > > SQL Query Analyzer.
> > > > > > > >
> > > > > > > >
> > > > > > > > Thanks.
> > > > > > > >
> > > > > > > > André
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Ola Hallengren" wrote:
> > > > > > > >
> > > > > > > > > >At each night, an automated backup is schedule and i stop/start sql server
> > > > > > > > > during that task.
> > > > > > > > >
> > > > > > > > > Could you give me some more information about how this is working. Is this a
> > > > > > > > > sql server agent job?
> > > > > > > > >
> > > > > > > > > Could you also give me some background for this backup strategy. In sql
> > > > > > > > > server it is possible to backup a database with the BACKUP DATABASE command
> > > > > > > > > while it is online.
> > > > > > > > >
> > > > > > > > > >I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update
> > > > > > > > >
> > > > > > > > > What if you just create a simple sql server agent tsql job and execute that?
> > > > > > > > >
> > > > > > > > > /Ola
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "inf0m286" wrote:
> > > > > > > > >
> > > > > > > > > > Hi Ola,
> > > > > > > > > >
> > > > > > > > > > I see no error in the server and agent log file. But, there is something
> > > > > > > > > > strange. At each night, an automated backup is schedule and i stop/start sql
> > > > > > > > > > server during that task. Normally, it create a new SQL log file and it's not
> > > > > > > > > > doing that since 03/17 .
> > > > > > > > > >
> > > > > > > > > > For the account that own SQL Server and Agent, it is the local system
> > > > > > > > > > account (in the definition on these services), so i think it has sysadmin
> > > > > > > > > > rights .
> > > > > > > > > >
> > > > > > > > > > Thanks
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Ola Hallengren" wrote:
> > > > > > > > > >
> > > > > > > > > > > You have no error messages in the sql server or sql server agent log file?
> > > > > > > > > > >
> > > > > > > > > > > Does the sql server agent service account have sysadmin rights?
> > > > > > > > > > >
> > > > > > > > > > > Ola Hallengren
> > > > > > > > > > > http://ola.hallengren.com
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > "inf0m286" wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > > > > > > > > > > 2008-03-13, the status won't be update. But, i know that the job still
> > > > > > > > > > > > running well. But the status of the next run date was OK.
> > > > > > > > > > > >
> > > > > > > > > > > > I have search on the web and i don't see anything that can help me.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > SQL2000 Standard Edition (two instance) (SP4)
> > > > > > > > > > > > Windows 2003 Server
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >

Refresh Access Client

Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?

It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.

Can DTS do this? The forms I'm talking about are select only, no editing.

I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.

Thanks,
CarlTry using Access Data Projects. It uses a direct connection to SQL Server and it is what I reccomend for all Access front ends because it provides performance improvements over local and linked tables.|||Cool, that's what we're doing, and ya, the performance increase is huge, even going from pc app to two tier.

I didn't know that would auto refresh my forms, I'll have to see what you mean, I was just telling the boss how tightly integrated sql server is with Access.

Myforms are firing stored procs for their recordsource, wouldn't I have to refire the proc?

Thanks again,
Carl|||yes. this response is too short.|||I ended up creating a one record, two field table, one's TGGL_BIT which flips back and forth between 0 and 1 and the datetime. The app grabs the state at startup, then polls a stored procedure every 5 seconds to look for the bit to toggle, if it does, it fires all the select procedures.

Suprisingly, it doesn't adversely affect the user experience and works pretty well.
Carl|||I also want to say we're looking into TCP/IP multicasting using java sockets. very cool stuff if we can get it going. We're thinking Flash listener may work on the client side.

Referential Integrity - Sequel Server 7.0

Hi,

i wrote the following trigger to enforce referential integrity:

CREATE TRIGGER [RefIntegrity] ON [Erf] <- Master table
FOR UPDATE AS

if update(ErfNo) or update(Township) <- Primary keys in master
begin
Update ErfPlan <- Child table
Set ErfPlan.ErfNo = i.ErfNo , ErfPlan.Township = i.Township
From ErfPlan a, Inserted i, Deleted d
Where a.ErfNo = d.ErfNo and a.Township = d.Township
end

i am using VB6.0. When my program updates one of the primary keys i get an error :
Key column information is insufficient or incorrect. Too many
rows were affected by update.

i have designed the ErfPlan table with a RcdID field (Autonumber).

This error ONLY occurs on existing records. If i create a new master and related child record, and update any of the key fields, VB displays no error!the funny thing about the vb error: if i requery the record that had a key value/s changed, i can see that it has been updated (for one-to-one AND one-to-many relationship). what i do not understand is why vb displays the error (Key column information is insufficient or incorrect. Too many rows were affected by update).
this error is only displayed when a master record has a one-to-many relationship, but not in a one-to-one relationship.

Referencing other databases in SQL Statements

Hello,

I have an access database and an SQL database and using data transformation services, i want to update the access database using the SQL data.

Can anyone tell me the syntax for referencing the access database?

Is it something like: [TABLENAME].dbo.FIELDNAME ?

Just to clarify, i have

Microsoft Access Database
Table 1 (UnitHistory)

SQL Database
Table 1 (UnitHistory)

How do i reference these seperately? I want to update the microsoft access database based on the SQL database data.

Eventually i'm trying to update an access database using the data held on my SQL server. Is DTS the best way for me to acomplish this or should i use another method?

Thanks guys1. look up in Sql book online for the syntax to create a linked server to Access.
2. do something like this to update Access:

Update A
set UnitHistory = S.UnitHistory
from [Access_linkedserver]...[Tb_name] A, [Sql_Tb_Name] S
where A.pkid=S.pkid
-- and

Reference an aggregate in where clause

I have two tables that are joined on 1 column.

I want to update one table using an aggregate from the other table.

I could just update all rows even if the aggregate value has not changed, but I wondered if there was a way to only update the records where the aggregate has changed.

I tried this code but assigning the name m to aggreate gives an error

UPDATE t2 SET t2.ColumnB = SELECT MAX(ColumnB) AS m From Table t1

JOIN t2 ON t1.ColumnA = t2.ColumnA

WHERE t2.ColumnB <> m

GROUP BY t1.ColumnA

Niall:

Does this meet your needs?

set nocount on

declare @.t1 table (ColumnA char(1), ColumnB int)
declare @.t2 table (ColumnA char(1), ColumnB int)

insert into @.t1 values ('A', 5)
insert into @.t1 values ('B', null)
insert into @.t1 values ('C', null)
--select * from @.t1

insert into @.t2 values ('A', 3)
insert into @.t2 values ('A', 5)
insert into @.t2 values ('A', 7)
insert into @.t2 values ('B', 2)
--select * from @.t2

set nocount off

update @.t1
set ColumnB = xt.columnb
from @.t1 as yt
inner join
( select t1.ColumnA,
max (t2.columnB) columnB
from @.t1 as t1
inner join @.t2 as t2
on t1.columnA = t2.columnA
group by t1.columnA
) xt
on xt.columnA = yt.columnA

set nocount on

select * from @.t1

-- --
-- Output
-- --

-- (2 row(s) affected)

-- ColumnA ColumnB
-- - --
-- A 7
-- B 2
-- C NULL

|||

Use a subquery - replace the 0 in the isnull calls with blank strings if your ColumnB is character data.

UPDATE Table2 SET ColumnB = t1.MaxB
FROM Table2 t2
INNER JOIN
(SELECT ColumnA, MAX(ColumnB) AS MaxB
FROM Table1
GROUP BY ColumnA) t1 ON t2.ColumnA = t1.ColumnA
WHERE isnull(t2.ColumnB, 0) <> isnull(t1.MaxB, 0)

Refer to ROWGUID col in update trigger

When writing an Update trigger on a table that has a UniqueIdentifier as the
primary key, how to I refer to the current row being updated.
I am used to using @.@.identity when working with primary keys that are of
type int but a UniqueIdentifier cannot be an identity column. I suspect it
has something to do with the "Is ROWGUID" property but I can't find the
function for getting the GUID of the row being updated.
Thanks,
Andrew.There isn't one. If you need to know this then you should generate the Guid
beforehand and use it in the insert statement.
--
Andrew J. Kelly
SQL Server MVP
"Andrew" <sql@.ses.ca> wrote in message
news:u3lnbAiRDHA.2636@.TK2MSFTNGP10.phx.gbl...
> When writing an Update trigger on a table that has a UniqueIdentifier as
the
> primary key, how to I refer to the current row being updated.
> I am used to using @.@.identity when working with primary keys that are of
> type int but a UniqueIdentifier cannot be an identity column. I suspect
it
> has something to do with the "Is ROWGUID" property but I can't find the
> function for getting the GUID of the row being updated.
> Thanks,
> Andrew.
>|||I want to access the row that is being updated, not inserted. The GUID is
already there.
Does this mean it is not possible to use a trigger to update a
"DateOfLastUpdate" field if the primary key is a GUID? I realize date could
be updated if the update was performed using a stored procedure but I feel
it would be safer to have this functionality on the table itself.
Thanks,
Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%237WJLGiRDHA.1552@.TK2MSFTNGP10.phx.gbl...
> There isn't one. If you need to know this then you should generate the
Guid
> beforehand and use it in the insert statement.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Andrew" <sql@.ses.ca> wrote in message
> news:u3lnbAiRDHA.2636@.TK2MSFTNGP10.phx.gbl...
> > When writing an Update trigger on a table that has a UniqueIdentifier as
> the
> > primary key, how to I refer to the current row being updated.
> >
> > I am used to using @.@.identity when working with primary keys that are of
> > type int but a UniqueIdentifier cannot be an identity column. I suspect
> it
> > has something to do with the "Is ROWGUID" property but I can't find the
> > function for getting the GUID of the row being updated.
> >
> > Thanks,
> > Andrew.
> >
> >
>|||> You threw me off when you mentioned @.@.IDENTITY. @.@.IDENTITY has nothing to
> do with an UPDATE, it is only useful for Inserts. Any time you want to
> reference a row that is being updated in a trigger you can use the
Inserted
> table. To update a datetime column you would simply do this:
> UPDATE YourTable SET ModDate = GETDATE()
> WHERE PK IN (SELECT i.PK FROM Inserted as i)
> This way it works when more than 1 rows is updated and there is no need to
> know what the actual value of the PK is.
I tend to use a wrapper like:
IF NOT UPDATE(ModDate)
Just to prevent recursion. :-)|||Thanks for your help. I had just "discovered" the inserted table but the
method I came up with is not as clean as yours.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uiAkt8iRDHA.3236@.TK2MSFTNGP10.phx.gbl...
> You threw me off when you mentioned @.@.IDENTITY. @.@.IDENTITY has nothing to
> do with an UPDATE, it is only useful for Inserts. Any time you want to
> reference a row that is being updated in a trigger you can use the
Inserted
> table. To update a datetime column you would simply do this:
> UPDATE YourTable SET ModDate = GETDATE()
> WHERE PK IN (SELECT i.PK FROM Inserted as i)
> This way it works when more than 1 rows is updated and there is no need to
> know what the actual value of the PK is.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Andrew" <sql@.ses.ca> wrote in message
> news:u53MXdiRDHA.2424@.tk2msftngp13.phx.gbl...
> > I want to access the row that is being updated, not inserted. The GUID
is
> > already there.
> >
> > Does this mean it is not possible to use a trigger to update a
> > "DateOfLastUpdate" field if the primary key is a GUID? I realize date
> could
> > be updated if the update was performed using a stored procedure but I
feel
> > it would be safer to have this functionality on the table itself.
> >
> > Thanks,
> > Andrew
> >
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > news:%237WJLGiRDHA.1552@.TK2MSFTNGP10.phx.gbl...
> > > There isn't one. If you need to know this then you should generate
the
> > Guid
> > > beforehand and use it in the insert statement.
> > >
> > > --
> > >
> > > Andrew J. Kelly
> > > SQL Server MVP
> > >
> > >
> > > "Andrew" <sql@.ses.ca> wrote in message
> > > news:u3lnbAiRDHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > > When writing an Update trigger on a table that has a
UniqueIdentifier
> as
> > > the
> > > > primary key, how to I refer to the current row being updated.
> > > >
> > > > I am used to using @.@.identity when working with primary keys that
are
> of
> > > > type int but a UniqueIdentifier cannot be an identity column. I
> suspect
> > > it
> > > > has something to do with the "Is ROWGUID" property but I can't find
> the
> > > > function for getting the GUID of the row being updated.
> > > >
> > > > Thanks,
> > > > Andrew.
> > > >
> > > >
> > >
> > >
> >
> >
>