Stack Overflow
Stack Overflow

Questions tagged [sql-job]

A job is a specified series of operations performed sequentially

Jobs define an administrative task that can be executed one or more times (manually or via a schedule) and monitored for success or failure each time it executes

272 questions
0
votes
0 answers

Automating Monthly SQL JOB/Query

I frequent this site a lot but have never posted but here goes! I am fairly new only about a month in on the job but have had some experience with SQL before. I have a simple query that runs monthly which counts the number of active members and…
Dylan Haines
  • 75
  • 7
0
votes
1 answer

SQL Stored Procedure fails to update data while the script in it works manually

I have a SQL Script that I execute in a job to transform tables periodically. To speed it up I put that script in a stored procedure and executed it with a job. It worked faster. The problem occurs at times when the stored procedure even though it…
sajidnizami
  • 467
  • 5
  • 15
0
votes
1 answer

Azure - Schedule SQL Job

I'm in the process of creating a small Azure site consisting of the following Website SQL Database The website supports user accounts and licensing. I plan on handling the licensing checks via a scheduled SQL service (Much like a SQL agent in SQL…
heymega
  • 9,215
  • 8
  • 42
  • 61
0
votes
1 answer

Need to delete all the files in a folder except the file which contains current datetime in the file name using sql job?

I have a text file in the name of BankDetails_09302014_153054.txt in one folder. I need to create a SQL job which will delete old files except current datetime file. (ie BankDetails_10012014_103104.txt). This sql job need to be execute on daily…
pyborg
  • 166
  • 10
0
votes
1 answer

Passing values into SSIS package

I've put together an SSIS package and deployed it to the SQL server. This package needs to be run on demand and needs to values passed into it, a batch number and the user ID of the person requesting the data. I've spent a fair amount researching…
Brad
  • 272
  • 2
  • 7
  • 22
0
votes
2 answers

Steps to create a sql server agent job to send emails daily

I have a query to retrieve the email ids from my demo table. I have also configured database email on my sql server. But I am new to sql server agent jobs. I want to send reminders to people who havent filled there daily task report at a specific…
Manish
  • 21
  • 1
  • 9
0
votes
3 answers

Asp.Net MVC And SQL server - Best way of using automated jobs

I'm desinging a web based game. In this game almost all actions will take certain amounth of time but i'm not sure about where to store and execute the actions. For example a character want to go to A to B and let's say this will take 30 secs. In my…
Sefa
  • 8,865
  • 10
  • 51
  • 82
0
votes
0 answers

I can execute SSIS on visual studio, but it doesn't in a job of SQL Server 2008

I have a simple SSIS package that I made in visual studio, it takes data from an Access data base and pass it to an SQL database. I can execute the package without any problems in Visual Studio 2008 but when I try to implement and execute it on a…
Luis Kråke
  • 11
  • 4
0
votes
1 answer

Run Excel Macro using SSIS throught SQL Jobs failed

I have a task to create Excel VBA and run that macro on SSIS. I can successfully run the Excel Macro from the SSIS Package, but I have a problem when I run that SSIS on SQL Jobs. I have created Credential, Proxy SSIS, and set SSIS unprotected, but…
subz
  • 19
  • 1
  • 7
0
votes
1 answer

Terminating a job in SQL Server during runtime

Is there a way to make a scheduled job terminate (stop, quit, stop executing, report failure) within a stored procedure in that job? For example, I have some check queries within a TRY block that do RAISERROR (59834,16,1) to go to the CATCH block to…
Chythe
  • 23
  • 6
0
votes
1 answer

SQL Job outputting as HTML Table instead of text

Ok so i have a job that runs with 4 separate select queries in it. EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Database Email', @recipients = 'dbcheck@xxx.com', @subject = 'SQL Replication Deletion Check', @query = ''SELECT…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
2 answers

SQL Job running a few select statements Incorrect syntax near '\'. [SQLSTATE 42000] (Error 102)

I have a SQL job that contains a few select statements (4 views and 1 text). EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Database Email', @recipients = 'dbcheck@xxx.com', @subject = 'SQL Replication Deletion Check', @query =…
Matt
  • 14,906
  • 27
  • 99
  • 149
0
votes
1 answer

Backup and restore SQL Server Management Studio job schedule

I've got a job in SQL Server Management Studio and I want to back up the schedule that it runs on so that the schedule can be applied to other jobs that I add. I know that I can get what I assume is the data I need to copy from using the…
Corey Maddie Besmer
  • 23
  • 1
  • 6
0
votes
1 answer

SQL Job stuck executing an SQL Merge?

I created a 2 step job at SQL Server 2008 which creates a table and then executes a MERGE command. Here are the steps: Create Table: CREATE TABLE CSVTable (AccountID INTEGER, UserType NVARCHAR (50), Lname NVARCHAR (50),…
Saudate
  • 431
  • 2
  • 8
  • 14
0
votes
1 answer

Job that runs java class and updates web server via AWS

I'm new to web servers. I have a java class that does a set of computations. I want to have this java class run every hour and update my domain on AWS, with the data. My question is how/where do I set this job to run? Is there a standard for this?…
emily
  • 467
  • 2
  • 6
  • 12
1 2 3
…
18 19