The sqlagent tag has no wiki summary.
0
votes
1answer
216 views
SQL server agent job to execute SSIS package fails, package succeds if run manually
I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
0
votes
1answer
166 views
How to trigger a SQL Agent Job from a client PC
I have SQL Agent job that is automated that a non SQL Admin user may need to occasionaly run. I know I can trigger a SQL Agent Job via sp_execute_job.
Can anyone tell me where to find what I need ...
1
vote
1answer
1k views
Configuring SQL Server Agent with domain account still fails to start Agent
I am trying to follow best practices for Sharepoint 2010 installation and SQL Server Agent will not start. My first reference is:
Installing SharePoint 2010 using Least Privilege Service Accounts
In ...
0
votes
1answer
53 views
SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication
I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown.
It looks like with fast Recovery, the database became available ...
2
votes
2answers
124 views
How do I configure the number of worker threads used by SqlServer 2005 Agent
How can I increase the limit of worker threads from the default 10 for SQL Server 2005 SqlAgent? I have 9 jobs that run almost continuously and that leaves only one available thread for the rest of ...
1
vote
1answer
482 views
How to schedule SQL-Agent to run a maintenance plan every x minutes?
My name is aSkywalker and I am an involuntary DBA.
I have done some research, and would like to back up transaction logs every 10 minutes.
I have written some powershell scripts to compress, encrypt ...
0
votes
1answer
880 views
Sql Agent Cannot Find the File Specified
I have a SQL 2008 Agent job with a single Operating system (CmdExec) step:
C:\Scripts\Script.cmd
Script.cmd runs a CS-Script.
If I run C:\Scripts\Script.cmd, everything appears fine - I get my ...
