Is there a limit to how many jobs you can have total - or a limit on
how many jobs can be running at one time.
I am looking at something that will use 600 very small jobs (take
about 2 seconds to run). WIll this cause a problem?
Thanks for any help.
AaronThe limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
Showing posts with label job. Show all posts
Showing posts with label job. Show all posts
Wednesday, March 21, 2012
MS SQL server 2000 Job limit?
Is there a limit to how many jobs you can have total - or a limit on
how many jobs can be running at one time.
I am looking at something that will use 600 very small jobs (take
about 2 seconds to run). WIll this cause a problem?
Thanks for any help.
AaronThe limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
how many jobs can be running at one time.
I am looking at something that will use 600 very small jobs (take
about 2 seconds to run). WIll this cause a problem?
Thanks for any help.
AaronThe limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
MS SQL server 2000 Job limit?
Is there a limit to how many jobs you can have total - or a limit on
how many jobs can be running at one time.
I am looking at something that will use 600 very small jobs (take
about 2 seconds to run). WIll this cause a problem?
Thanks for any help.
Aaron
The limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
|||The limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
how many jobs can be running at one time.
I am looking at something that will use 600 very small jobs (take
about 2 seconds to run). WIll this cause a problem?
Thanks for any help.
Aaron
The limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
|||The limit you would be more likely to hit would be worker
threads per job subsystem. You can view the subsystems and
their max worker threads by executing:
exec msdb..sp_enum_sqlagent_subsystems
You can modify the CmdExec, ActiveScripting and TSQL max
worker threads by modifying the values in the registry if
needed. The registry keys for CmdExec and ActiveScripting
exist in the registry - for TSQL threads, you need to create
the key.
-Sue
On 28 Jun 2004 07:06:08 -0700, aewood21@.yahoo.com (Aaron
Wood) wrote:
>Is there a limit to how many jobs you can have total - or a limit on
>how many jobs can be running at one time.
>I am looking at something that will use 600 very small jobs (take
>about 2 seconds to run). WIll this cause a problem?
>Thanks for any help.
>Aaron
Monday, March 12, 2012
MS SQL Operator Job Alerts via SMS
Hey guys,
I was just thinking, is it possible to send alerts via the Managment/SQL Server Agent/Operators/Alerts to an SMS system?
Is it even technically posibble?
Actually I am trying to develop an alert system that reads the database table periodcally, the data being read is a datetime, once it reaches the time, I need to send an sms to the person.
Any suggestions? ideas? Quickest solution?If your SMS provides an email address, I think that's the fastest and easiest answer.
-PatP
I was just thinking, is it possible to send alerts via the Managment/SQL Server Agent/Operators/Alerts to an SMS system?
Is it even technically posibble?
Actually I am trying to develop an alert system that reads the database table periodcally, the data being read is a datetime, once it reaches the time, I need to send an sms to the person.
Any suggestions? ideas? Quickest solution?If your SMS provides an email address, I think that's the fastest and easiest answer.
-PatP
MS SQL Jobs
Hi SQL Guru's
I am trying to run a job on Multiple SQL Servers in a domain.I am setting the job on my system,but the Radio button "Target Multiple Servers" is disabled.How do I enable the radio button "Target Multiple Servers".
Please let me know if this is possible.
Best Regards
SK.you have to ensure that your machine is a master and that you have
registered servers to be targets.
Right click sql server agent -- Multi Server Administration -- Make this a master.
During this process you will be asked to create a MSX operator. and to enlist targets. the targets will need to be pre-registered with your master's instance and then define the jobs on the master and then you will be able to target multiple servers.
understand that this process is designed to return all job history to the master so you can check the progress of job operations from one place. however, just as with the highlander, there can be only one.... meaning that a target cannot be a master for other servers.
:confused: and dont forget to check books online,
BOOKS ONLINE {Multiserver Administration}
I am trying to run a job on Multiple SQL Servers in a domain.I am setting the job on my system,but the Radio button "Target Multiple Servers" is disabled.How do I enable the radio button "Target Multiple Servers".
Please let me know if this is possible.
Best Regards
SK.you have to ensure that your machine is a master and that you have
registered servers to be targets.
Right click sql server agent -- Multi Server Administration -- Make this a master.
During this process you will be asked to create a MSX operator. and to enlist targets. the targets will need to be pre-registered with your master's instance and then define the jobs on the master and then you will be able to target multiple servers.
understand that this process is designed to return all job history to the master so you can check the progress of job operations from one place. however, just as with the highlander, there can be only one.... meaning that a target cannot be a master for other servers.
:confused: and dont forget to check books online,
BOOKS ONLINE {Multiserver Administration}
Wednesday, March 7, 2012
MS SQL 5.0
Hi,
We are having a migration job to do. The customer is saying that the SQL
Server version 5.0
I never heard this version before? Is there any such version there last time?
I knew the version ofrom 6.5 onwards.
Please help me to find there was such version before and will it be
compatible to migrate say to MS SQL Server 2000 or later versions?
Thanks
Regards
kumarMSSQL ver5.0 SP4 running on
Microsoft Window Server 2000.
"kumar" wrote:
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||There never existed such version of MS SQL Server. The version history is (from memory):
1.0 (OS/2)
1.1 (OS/2)
4.2 (OS/2)
4.21... (OS/2 and NT)
6.0 (NT)
6.5 (NT/Windows)
7.0 (NT/Windows)
2000/8.0 (NT/Windows)
2005/9.0 (Windows)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Ask them to send you the version string. The two possibilities I can think
of is they are giving you the Windows version from the @.@.version output - I
think Windows 2000 is displayed as Windows NT 5.0 or they don't have SQL
Server. mySQL has a version 5.0 for example.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last
> time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Are they sure it's Microsoft SQL Server?
The current non-beta release of MySQL is version 5.0
-Sue
On Thu, 4 May 2006 00:39:01 -0700, kumar
<kumar@.discussions.microsoft.com> wrote:
>Hi,
>We are having a migration job to do. The customer is saying that the SQL
>Server version 5.0
>I never heard this version before? Is there any such version there last time?
>I knew the version ofrom 6.5 onwards.
>Please help me to find there was such version before and will it be
>compatible to migrate say to MS SQL Server 2000 or later versions?
>Thanks
>Regards
>kumar
We are having a migration job to do. The customer is saying that the SQL
Server version 5.0
I never heard this version before? Is there any such version there last time?
I knew the version ofrom 6.5 onwards.
Please help me to find there was such version before and will it be
compatible to migrate say to MS SQL Server 2000 or later versions?
Thanks
Regards
kumarMSSQL ver5.0 SP4 running on
Microsoft Window Server 2000.
"kumar" wrote:
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||There never existed such version of MS SQL Server. The version history is (from memory):
1.0 (OS/2)
1.1 (OS/2)
4.2 (OS/2)
4.21... (OS/2 and NT)
6.0 (NT)
6.5 (NT/Windows)
7.0 (NT/Windows)
2000/8.0 (NT/Windows)
2005/9.0 (Windows)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Ask them to send you the version string. The two possibilities I can think
of is they are giving you the Windows version from the @.@.version output - I
think Windows 2000 is displayed as Windows NT 5.0 or they don't have SQL
Server. mySQL has a version 5.0 for example.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last
> time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Are they sure it's Microsoft SQL Server?
The current non-beta release of MySQL is version 5.0
-Sue
On Thu, 4 May 2006 00:39:01 -0700, kumar
<kumar@.discussions.microsoft.com> wrote:
>Hi,
>We are having a migration job to do. The customer is saying that the SQL
>Server version 5.0
>I never heard this version before? Is there any such version there last time?
>I knew the version ofrom 6.5 onwards.
>Please help me to find there was such version before and will it be
>compatible to migrate say to MS SQL Server 2000 or later versions?
>Thanks
>Regards
>kumar
MS SQL 5.0
Hi,
We are having a migration job to do. The customer is saying that the SQL
Server version 5.0
I never heard this version before? Is there any such version there last time
?
I knew the version ofrom 6.5 onwards.
Please help me to find there was such version before and will it be
compatible to migrate say to MS SQL Server 2000 or later versions?
Thanks
Regards
kumarMSSQL ver5.0 SP4 running on
Microsoft Window Server 2000.
"kumar" wrote:
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last ti
me?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||There never existed such version of MS SQL Server. The version history is (f
rom memory):
1.0 (OS/2)
1.1 (OS/2)
4.2 (OS/2)
4.21... (OS/2 and NT)
6.0 (NT)
6.5 (NT/Windows)
7.0 (NT/Windows)
2000/8.0 (NT/Windows)
2005/9.0 (Windows)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last ti
me?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Ask them to send you the version string. The two possibilities I can think
of is they are giving you the Windows version from the @.@.version output - I
think Windows 2000 is displayed as Windows NT 5.0 or they don't have SQL
Server. mysql has a version 5.0 for example.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last
> time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Are they sure it's Microsoft SQL Server?
The current non-beta release of mysql is version 5.0
-Sue
On Thu, 4 May 2006 00:39:01 -0700, kumar
<kumar@.discussions.microsoft.com> wrote:
>Hi,
>We are having a migration job to do. The customer is saying that the SQL
>Server version 5.0
>I never heard this version before? Is there any such version there last tim
e?
>I knew the version ofrom 6.5 onwards.
>Please help me to find there was such version before and will it be
>compatible to migrate say to MS SQL Server 2000 or later versions?
>Thanks
>Regards
>kumar
We are having a migration job to do. The customer is saying that the SQL
Server version 5.0
I never heard this version before? Is there any such version there last time
?
I knew the version ofrom 6.5 onwards.
Please help me to find there was such version before and will it be
compatible to migrate say to MS SQL Server 2000 or later versions?
Thanks
Regards
kumarMSSQL ver5.0 SP4 running on
Microsoft Window Server 2000.
"kumar" wrote:
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last ti
me?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||There never existed such version of MS SQL Server. The version history is (f
rom memory):
1.0 (OS/2)
1.1 (OS/2)
4.2 (OS/2)
4.21... (OS/2 and NT)
6.0 (NT)
6.5 (NT/Windows)
7.0 (NT/Windows)
2000/8.0 (NT/Windows)
2005/9.0 (Windows)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last ti
me?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Ask them to send you the version string. The two possibilities I can think
of is they are giving you the Windows version from the @.@.version output - I
think Windows 2000 is displayed as Windows NT 5.0 or they don't have SQL
Server. mysql has a version 5.0 for example.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"kumar" <kumar@.discussions.microsoft.com> wrote in message
news:CD202903-1262-4045-A462-C60FC03A75F1@.microsoft.com...
> Hi,
> We are having a migration job to do. The customer is saying that the SQL
> Server version 5.0
> I never heard this version before? Is there any such version there last
> time?
> I knew the version ofrom 6.5 onwards.
> Please help me to find there was such version before and will it be
> compatible to migrate say to MS SQL Server 2000 or later versions?
> Thanks
> Regards
> kumar
>|||Are they sure it's Microsoft SQL Server?
The current non-beta release of mysql is version 5.0
-Sue
On Thu, 4 May 2006 00:39:01 -0700, kumar
<kumar@.discussions.microsoft.com> wrote:
>Hi,
>We are having a migration job to do. The customer is saying that the SQL
>Server version 5.0
>I never heard this version before? Is there any such version there last tim
e?
>I knew the version ofrom 6.5 onwards.
>Please help me to find there was such version before and will it be
>compatible to migrate say to MS SQL Server 2000 or later versions?
>Thanks
>Regards
>kumar
Subscribe to:
Comments (Atom)