Top "Sql-agent-job" questions

The job failed. The job was invoked by user<user>. The last step to run was step1

I have created SSIS package which is running successfully and dumping the data to the required place. But the same …

sql ssis job-scheduling sql-agent-job
How execute exe file from sql agent or job?

I don't want to hit the database frequently based on page request, so I planned to create a xml file …

c# sql sql-agent-job
I need best practice in T-SQL Export data to CSV (with header)

What I need to do is export data into CSV file using T-SQL. And I'm very confused about there are …

sql tsql csv sqlcmd sql-agent-job
How to pass a parameter to a SQL Job that will execute a stored procedure

I have the below code (only the portion that is needed) EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@…

sql-server sql-server-2008 tsql sql-agent-job
SQL xp_cmdshell copy files between servers

I am trying to move all .zip in a specific folder to another folder. the source folder is located on …

sql sql-server sql-agent-job xp-cmdshell
Create SQL Server Agent job for stored procedure with input parameter

Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter? The …

sql sql-server tsql stored-procedures sql-agent-job
How to Partition a Table by Month ("Both" YEAR & MONTH) and create monthly partitions automatically?

I'm trying to Partition a Table by both Year and Month. The Column through which I'll partition is a datetime …

sql sql-server partitioning dynamic-sql sql-agent-job
How to skip a job step based on outcome of previous SQL Agent job step?

I'm trying to create a job that will run based on the online status of a database. For example, step 1 …

sql-server tsql sql-agent-job
SQL Agent Job: Determine how long it has been running

The Scenario There are certain SQL Agent Jobs that are scheduled to run every few minutes throughout the day. There …

sql sql-server sql-server-2008 sql-agent-job
How to Export data to Excel in SQL Server using SQL Jobs

I need to export the data from a particular table in my database to Excel files (.xls/.xlsx) that will …

sql excel sql-server-2008 export-to-excel sql-agent-job