Select Statements in Jobs

Posted by Andrew Vogel on Stack Overflow See other posts from Stack Overflow or by Andrew Vogel
Published on 2010-05-17T15:23:09Z Indexed on 2010/05/17 15:30 UTC
Read the original article Hit count: 305

Filed under:

sql-job

I have inherited a few jobs and I am trying to understand why select statements would be in their steps. I would think that select statements would be pointless in an automated job that displays nothing for an end user.

Related posts about sql-job

Using BizTalk to bridge SQL Job and Human Intervention (Requesting Permission)

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I start off the process with either a BizTalk Scheduler (http://biztalkscheduledtask.codeplex.com/releases/view/50363) or a manual file drop of the XML message. The manual file drop is to allow the SQL Job to call a "File Copy" SSIS step to copy the trigger file for the next process and allows… >>> More
SQL Job: CmdExec with Multiple Arguments

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to specify two arguments to CmdExec in SQL JOb Step? I have MyApp.exe Para1 Para2 but it only recognize para1. >>> More
Cannot Delete a SQL job.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have disabled log shipping on a SQL 2005 database and deleted the log shipping DB on the secondary server. However i cannot delete the LSRestore_DB___ job, either by T-SQL (sp_delete_log_shipping_primary_secondary, sp_delete_job) or using the management studio on the secondary server. It just… >>> More
problem with sql job and datetime parameter

as seen on Stack Overflow - Search for 'Stack Overflow'
Another developer created a stored procedure that is set up to run as a sql job each month. It takes one parameter of datetime. When I try to invoke it in the job or in just a query window I get an error "Incorrect syntax near ')'" The call to execute it is... exec CreateHeardOfUsRecord getdate() When… >>> More
Select Statements in Jobs

as seen on Stack Overflow - Search for 'Stack Overflow'
I have inherited a few jobs and I am trying to understand why select statements would be in their steps. I would think that select statements would be pointless in an automated job that displays nothing for an end user. >>> More

Developer IT

Select Statements in Jobs - Developer IT

Select Statements in Jobs

sql-job

Related posts about sql-job

Using BizTalk to bridge SQL Job and Human Intervention (Requesting Permission)

SQL Job: CmdExec with Multiple Arguments

Cannot Delete a SQL job.

problem with sql job and datetime parameter

Select Statements in Jobs

Categories cloud