Purpose of SQL Server Agent Service

Can someone explain the purpose of the SQL Server Agent Service?
"Ivan Svaljek" <ivan.svaljek@.gmail.com> wrote in message
news:bc7d369f.0503071452.24917756@.posting.google.c om...
> Can someone explain the purpose of the SQL Server Agent Service?
It lets you schedule jobs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||Not only that, you can also set alerts for certain conditions on the server
and notify operators when a job completes or aborts.
-Argenis
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uA5C6n2IFHA.904@.tk2msftngp13.phx.gbl...
> "Ivan Svaljek" <ivan.svaljek@.gmail.com> wrote in message
> news:bc7d369f.0503071452.24917756@.posting.google.c om...
> It lets you schedule jobs.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>

Purpose of SQL Server Agent Service

Can someone explain the purpose of the SQL Server Agent Service?"Ivan Svaljek" <ivan.svaljek@.gmail.com> wrote in message
news:bc7d369f.0503071452.24917756@.posting.google.com...
> Can someone explain the purpose of the SQL Server Agent Service?
It lets you schedule jobs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Not only that, you can also set alerts for certain conditions on the server
and notify operators when a job completes or aborts.
-Argenis
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uA5C6n2IFHA.904@.tk2msftngp13.phx.gbl...
> "Ivan Svaljek" <ivan.svaljek@.gmail.com> wrote in message
> news:bc7d369f.0503071452.24917756@.posting.google.com...
> It lets you schedule jobs.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>

Purpose of SQL Server Agent Service

Can someone explain the purpose of the SQL Server Agent Service?"Ivan Svaljek" <ivan.svaljek@.gmail.com> wrote in message
news:bc7d369f.0503071452.24917756@.posting.google.com...
> Can someone explain the purpose of the SQL Server Agent Service?
It lets you schedule jobs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Not only that, you can also set alerts for certain conditions on the server
and notify operators when a job completes or aborts.
-Argenis
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uA5C6n2IFHA.904@.tk2msftngp13.phx.gbl...
> "Ivan Svaljek" <ivan.svaljek@.gmail.com> wrote in message
> news:bc7d369f.0503071452.24917756@.posting.google.com...
> > Can someone explain the purpose of the SQL Server Agent Service?
> It lets you schedule jobs.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>

Punctuation marks

Does anyone have a list of all punctuation marks ignored by the full-text
indexing service by default. Noise files (i.e. noise.dat) only explicitly
list the dollar sign ($) and the underscore (_) as noise "words".
And another observation - the Windows implementation of MS Search (compared
to the MS SQL Server implementation) yields different results - try searching
for files with the "|" character in the file name. Ok, it's an illegal
character, but the result is at least 'interesting'.
As far as the rest of the characters ignored in SQL FTS are concerned, they
don't bother Windows search. Has anyone else come across these (or other)
discrepancies?
ML
I take it you are only talking about SQL FTS, you mention Indexing Services
and MSSearch in here which are two separate products although SQL FTS uses
the MSSearch engine.
SQL FTS indexes alphanumeric characters. Most other characters are not
indexed but the engine is aware that something existed there. So a search on
AT&T will match with AT&T, AT!T, AT*T, AT$T, and AT T, if A, T, and At are
not in your noise word list.
..,!:; are discarded.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:F406D8AB-E6AA-4C21-BF8E-51010B809459@.microsoft.com...
> Does anyone have a list of all punctuation marks ignored by the full-text
> indexing service by default. Noise files (i.e. noise.dat) only explicitly
> list the dollar sign ($) and the underscore (_) as noise "words".
> And another observation - the Windows implementation of MS Search
> (compared
> to the MS SQL Server implementation) yields different results - try
> searching
> for files with the "|" character in the file name. Ok, it's an illegal
> character, but the result is at least 'interesting'.
> As far as the rest of the characters ignored in SQL FTS are concerned,
> they
> don't bother Windows search. Has anyone else come across these (or other)
> discrepancies?
>
> ML
|||Thank you, very much. Yes, mainly I'm referring to SQL FTS and I'm aware of
the fact tha SQL FTS and Windows Indexing Services two are separate products.
I'm just baffled by the fact that the two implementations of the MSSearch
engines differ in such a way. Any idea why?
Thanks for the list as well.
ML

Publishing a report programmatically.

Hi!

I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

Hello Vivekananda:

SQL Server 2005 Reporting Services (SSRS) provides a full-featured set of APIs that you can use to integrate Reporting Services with custom business applications and extend its functionality.

The Report Server Web service provides access to the full functionality of the report server.

A Report Server Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API. You can use the Web service to add the functionality of Reporting Services to your business applications.

For more information of the Report Server Web Service:

http://msdn2.microsoft.com/fr-fr/library/ms152787(SQL.90).aspx

ReportingService2005 Class contains the methods and properties that can be used to call the Microsoft SQL Server 2005 Reporting Services (SSRS) Web service.

You can use the method 'ReportingService2005.CreateReport' to create new report to the report server database.

Here is a code example for this:

Code Snippet

class Sample
{
public static void Main()
{
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte[] definition = null;
Warning[] warnings = null;
string name = "MyReport";

try
{
FileStream stream = File.OpenRead("MyReport.rdl");
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int) stream.Length);
stream.Close();
}

catch(IOException e)
{
Console.WriteLine(e.Message);
}

try
{
warnings = rs.CreateReport(name, "/Samples", false, definition, null);

if (warnings != null)
{
foreach (Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
}

else
Console.WriteLine("Report: {0} created successfully with no warnings", name);
}

catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}

}
}

Hope this helps.

For more information:

Report Server Web Service Features

Report Server Namespace Management Methods

Good luck.

Publishing a report programmatically.

Hi!

I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

Hello Vivekananda:

SQL Server 2005 Reporting Services (SSRS) provides a full-featured set of APIs that you can use to integrate Reporting Services with custom business applications and extend its functionality.

The Report Server Web service provides access to the full functionality of the report server.

A Report Server Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API. You can use the Web service to add the functionality of Reporting Services to your business applications.

For more information of the Report Server Web Service:

http://msdn2.microsoft.com/fr-fr/library/ms152787(SQL.90).aspx

ReportingService2005 Class contains the methods and properties that can be used to call the Microsoft SQL Server 2005 Reporting Services (SSRS) Web service.

You can use the method 'ReportingService2005.CreateReport' to create new report to the report server database.

Here is a code example for this:

Code Snippet

class Sample
{
public static void Main()
{
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte[] definition = null;
Warning[] warnings = null;
string name = "MyReport";

try
{
FileStream stream = File.OpenRead("MyReport.rdl");
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int) stream.Length);
stream.Close();
}

catch(IOException e)
{
Console.WriteLine(e.Message);
}

try
{
warnings = rs.CreateReport(name, "/Samples", false, definition, null);

if (warnings != null)
{
foreach (Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
}

else
Console.WriteLine("Report: {0} created successfully with no warnings", name);
}

catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}

}
}

Hope this helps.

For more information:

Report Server Web Service Features

Report Server Namespace Management Methods

Good luck.

Publisher Issues

Right i have two sql 2005 standard edition boxes within a Windows 2003 R2 active directory environment. All updates sp1 etc.

I have an mssql service account setup in AD which all the mssql services on both servers startup with.
I went to setup replication between the two servers for one db.
Firstly i setup distribution no problems no errors.

Then i went to setup the publication, all went well no errors in management studio gui but in the application event logs i got the following:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 14151
Date: 05/10/2006
Time: 12:37:43
User: DNETWORK\mssqlservice
Computer: SGC
Description:
Replication-Replication Transaction-Log Reader Subsystem: agent SGC-MerakDB-2 failed. Executed as user: dnetwork\sqlrep. A required privilege is not held by the client. The step failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 47 37 00 00 12 00 00 00 G7......
0008: 04 00 00 00 53 00 47 00 ....S.G.
0010: 43 00 00 00 0d 00 00 00 C.......
0018: 64 00 69 00 73 00 74 00 d.i.s.t.
0020: 72 00 69 00 62 00 75 00 r.i.b.u.
0028: 74 00 69 00 6f 00 6e 00 t.i.o.n.
0030: 00 00

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 14151
Date: 05/10/2006
Time: 12:37:51
User: DNETWORK\mssqlservice
Computer: SGC
Description:
Replication-Replication Snapshot Subsystem: agent SGC-MerakDB-Merak Mail DB-2 failed. Executed as user: dnetwork\sqlrep. A required privilege is not held by the client. The step failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 47 37 00 00 12 00 00 00 G7......
0008: 04 00 00 00 53 00 47 00 ....S.G.
0010: 43 00 00 00 0d 00 00 00 C.......
0018: 64 00 69 00 73 00 74 00 d.i.s.t.
0020: 72 00 69 00 62 00 75 00 r.i.b.u.
0028: 74 00 69 00 6f 00 6e 00 t.i.o.n.
0030: 00 00

I've tried all sorts to get this to work, the sqlrep user is db_owner for the distro db, ive tried the sqlrep user as domain admin to see if it was a system priv issue, no luck :(

Anyone have any ideas?

Is the account dnetwork\sqlrep the same as SQL Server service account? You can try to add dnetwork\sqlrep to windows user group SQLServer2005SQLAgentUser$<MachineName>$MSSQLSERVER, SQLServer2005MSSQLUser$<MachineName>$MSSQLSERVER, then restart SQL Server service, or reboot the machine to see if the problem goes away. Also can you let us know if you have changed SQL Server service account after installation? If so, it has to be done through SQL Server configuration manager.

Thanks,

Zhiqiang Feng

|||

I tried what you suggested, no luck,

theres a service account for mssql which i named mssqlservice :)
That was set during setup and never changed.

sqlrep was created for replication only, i had already added it to the groups you suggested with no luck. The same error etc.

So i uninstalled then reinstalled mssql from scratch no problems this time.

I believe it was down to a active directory issue when we had to run gpofix it may have altered something down the line. The issue was effecting both servers so i assume it was caused by the active directory issue.

Bit strange though but its sorted now, well so far so good :)

Publisher and Subscriber with different service packs

We have several SQL Server 2000 databases servers. We would like to do
snapshot replication to a central server. The central server would be sp3a
and most of the servers are sp3a. We still have a couple of machines at sp2
and will be upgrading shortly.. My question is: Can snapshot replication
work between Servers with different service packs. Thanks... in advance
tiny
Snapshot replication is the most forgiving replication type when it comes to
differencing service pack levels.
You should have no problems.
"Tiny13" <Tiny13@.discussions.microsoft.com> wrote in message
news:A8607009-C020-4125-B01E-EF2DB5F334E7@.microsoft.com...
> We have several SQL Server 2000 databases servers. We would like to do
> snapshot replication to a central server. The central server would be
> sp3a
> and most of the servers are sp3a. We still have a couple of machines at
> sp2
> and will be upgrading shortly.. My question is: Can snapshot replication
> work between Servers with different service packs. Thanks... in advance
> tiny

PTS sp4 causes Distinct Count error

I have Analyisis Sevices service pack 3a. Office xp has been installed on the client machines and the server, which has installed PTS service pack 4. This has resulted in one of the calculated members showing as #1NF in Proclarity. It works perfectly well from client machines still running with PTS service pack 3. The calculated member in question uses a distinct count which is now always returning 0.

Does anyone have any suggestions? Thanks.

If the cube where it happens is a virtual cube - then it is a known regression in SP4 w.r.t. DistinctCount MDX function. There is a hotfix avaialable - please contact product support in order to obtain it.|||

Hello,

Yes it is a virtual cube. Is the hotfix for Analysis services sp4? The server is still on Analysis services sp3a but PTS got upgraded when office xp was installed.

Thanks for your help.

|||Yes, the hotfix is on top of SP4 and should be applied to PTS.

PTS sp4 causes Distinct Count error

I have Analyisis Sevices service pack 3a. Office xp has been installed on the client machines and the server, which has installed PTS service pack 4. This has resulted in one of the calculated members showing as #1NF in Proclarity. It works perfectly well from client machines still running with PTS service pack 3. The calculated member in question uses a distinct count which is now always returning 0.

Does anyone have any suggestions? Thanks.

If the cube where it happens is a virtual cube - then it is a known regression in SP4 w.r.t. DistinctCount MDX function. There is a hotfix avaialable - please contact product support in order to obtain it.|||

Hello,

Yes it is a virtual cube. Is the hotfix for Analysis services sp4? The server is still on Analysis services sp3a but PTS got upgraded when office xp was installed.

Thanks for your help.

|||Yes, the hotfix is on top of SP4 and should be applied to PTS.