Top "Sql-job" questions

How do I make a sql job step quit reporting failure

I have a sql job step like this Declare @Result varchar(255) exec myprocedure @Result = @Result output What I want to …

sql-server-2005 tsql sql-job

Is there a way to set a SQL Server job scheduled to run every 30 seconds?

When I try to create a Schedule the minimum amount of time I can choose from is 1 minute, is there …

sql-server scheduled-tasks sql-job

SQL Server Agent Job is not running

I have a job that is supposed to run every 11 AM and 8 PM. About two weeks ago, it started to …

sql sql-server-agent sql-job

How to stop a SQL job showing 'In Progress' status?

I am using SQL Server 2014 and I have a job (called ITB) which has been scheduled to run at 4.00am …

sql-server ssms sql-job

How to get the value from step1 to step2 in sql Job

I need to create a SQL JOB. Step1: Insert a Row into TaskToProcess Table and return ProcessID(PK and Identity) …

sql-server-2008 ssis sql-job

Running SSIS from an SQL job by passing parameters

Is it possible to send parameters like @inputfile, @packagepath etc. to my sql job which will run my SSIS? Currently …

ssis sql-job