The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
3answers
67 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
2answers
44 views

SQL Agent started with local user account can't run job with domain user account

I have SQL Agent running under a local user account. Jobs runs well if I used Local account credentials for the cmdExec step. If I try to use a domain user account (created previously in proxies ...
4
votes
3answers
211 views

Scheduled Jobs during hours of autumn time change

I'm wondering how other people deal with this scenario. What if you have a job scheduled to run at 1:30 am. In the autumn, when time changes, the hour of 1:00:00 to 1:59:59 repeats itself and so ...
0
votes
2answers
364 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
209 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
2k 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
55 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
133 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
510 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
965 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 ...