Best place for job posting?

We are looking to place a job posting for a developer experienced in SSIS
and SSRS. Are there any recommendations for the best place to post the job
offer?
thank you,
Bob M..http://jobs.sqlservercentral.com/
"Bob Murdoch" <ram_re_move_5@.erols.com> wrote in message
news:eeG7TzXAIHA.4956@.TK2MSFTNGP06.phx.gbl...
> We are looking to place a job posting for a developer experienced in SSIS
> and SSRS. Are there any recommendations for the best place to post the
> job offer?
> thank you,
> Bob M..
>|||"Dean" <deanl144@.hotmail.com.nospam> wrote:..
> http://jobs.sqlservercentral.com/
>
Thank you for the reply Dean. It looks like there is a grand total of four
job postings on this site, which seems to indicate it may not be one of the
'best' places to post a job offer.
Am I reading the site correctly?
Bob M..

being notified when replication stops

Jennyfer,
like Sam says, you can add an additional step in your
replication job. This is the way I do it as I have to use
SMTP emails. As an alternative, you might use the inbuilt
Replication: agent failure alert.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
I also have the same problem, i don't need a notification but i want the
agent to start synchronising again...may be after some time ... is it
possible?
"Paul Ibison" wrote:

> Jennyfer,
> like Sam says, you can add an additional step in your
> replication job. This is the way I do it as I have to use
> SMTP emails. As an alternative, you might use the inbuilt
> Replication: agent failure alert.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

behavior of ssis packages running under SSMS manually vs. job agent automatically

I have a ssis package that has multiple large lookups without memory restriction. When running the package manually from SSMS on the same server it runs on when running automatically under the job agent, the package errors out when the server memory gets depleted by the loading of the large lookup reference data. One of the messages I get is

"An out-of-memory condition prevented the creation of the buffer object. "

Anyway, the package runs successfully when it runs automatically under the job agent.

I was curious as to why the above happens. Is that a bug or is the run time behavior different under these 2 environments by design.

js40

If you are running through SSMS, you are likley executing the package via your machine, not the server. Do you have the full SSIS client installed? (Do you have a SQL Server Integration Service service when looking at "Services" under the control panel?)|||

No, i ran the package on the same server as where it runs automatically under sql agent. I started it manually from SMSS under remote desktop. The server is sql server 2005 (64 bit) with SP1 and 8gig memory.

Actually, several times it crashed SMSS and the last thing I saw just before the SMSS window just plain disappeared was some errors related to memory.

Below are different errors i got when i ran this package serveral times.

1) The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state.

2)The system reports 99 percent memory load. There are 8588873728 bytes of physical memory with 67133440 bytes free. There are 2147352576 bytes of virtual memory with 27369472 bytes free. The paging file has 12954959872 bytes with 4205600768 bytes free.

3)A buffer failed while allocating 2048 bytes.

4)An out-of-memory condition prevented the creation of the buffer object.

js40