Recently I have had a customer complaining that when he is adding more subscriptions to his publication, distribution agent job for the newly added subscriptions would not start. And when he tried to start the distribution agent job manually, it failed with below error
SQLServerAgent Error: Request to run job Job_id (from User distributor_admin) refused because the job is already running from a request by User distributor_admin. Changed database context to 'db_name'. (Microsoft SQL Server, Error: 22022)
But when he checked the subscription status in Replication Monitor, it says NOT RUNNING. Quite Weird!!
This is how the troubleshooting began:
Limitation: one second delay between starting jobs
<<From KB 306457>>
A design limitation imposes a one second delay between jobs. This limitation was set so that the job scheduler does not monopolize the resources on the hosting server. Because of this limitation, up to 60 jobs can be started in the same one-minute interval. If jobs run and finish in less than one minute and are started at the same time based on a one-minute schedule, some jobs may never run. The jobs may never run because jobs that were already executed are retriggered every minute. Other jobs are left in a starvation situation.
Important: This information applies to starting news jobs and does not impose a limitation on jobs that are running at the same time. We recommend that you group jobs into batches of less than 60 simultaneous jobs and stage schedules so that there is enough bandwidth for SQL Server Agent to run these jobs.
<</From KB 306457>>
So for all the new subscriptions that customer added, we created a different schedule so that there is enough bandwidth for SQL Server Agent to run these jobs.
Additional Info: http://support.microsoft.com/kb/306457
Written By: Prema Kolli - Support Engineer,Microsoft GTSC
Reviewed By: Akbar Farishta - Technical Lead, Microsoft GTSC Ouseph Devis T - Technical Lead, Microsoft GTSC
The article is good. Prema could you also confirm if the above article is applicable for which versions of SQL Server? Also please check the Support link provided towards the end of the article. The link is not proper.
I have a package that reads from a csv file and writes the content into SQL Server. I'm having trouble with a file not being fully read when my SSIS package is run in a job. If I manually run the job (using the same login that the job uses), the whole file is read and written to the SQL Server destination. When a job kicks of the package, I get an error message about column delimiters being absent. I think this is because the file is only partially read, and gets truncated in the middle of a value for one of the columns.
Is there a limit on file sizes for jobs?