Stack Overflow
Stack Overflow

Questions tagged [sql-server-job]

A SQL Server Job is a task that can be executed by the SQL Server Agent

SQL Server allows the creation of individual jobs, repeatable processes which can be run on-demand or via a preset schedule.

Each job consists of one or more job steps, which are executed in sequence. A job step can be one of the following:

  • Executable programs and operating system commands.

  • Transact-SQL statements, including stored procedures and extended stored procedures.

  • PowerShell scripts.

  • Microsoft ActiveX scripts.

  • Replication tasks.

  • Analysis Services tasks.

  • Integration Services packages.

SQL Server jobs are operated through the SQL Server Agent. Frequent uses include database maintenance tasks, ETL package execution, cube processing, and script execution.

55 questions
0
votes
0 answers

Cannot run a batch file from SQL Server Agent (Access denied)

I am trying to execute a batch file from SQL Server Agent (as it needs to be done before some SSIS-packages are run). When I execute the job it fails in a few seconds saying "Access denied". The account under which SQL Server Agent runs has full…
analyzethat
  • 191
  • 1
  • 16
0
votes
0 answers

Database Backup Failure SQL Server 2012 Enterprise

I am running a split disk backup such as: BACKUP DATABASE [At] TO DISK = N'O:\sql_bak\At_full1.bak', DISK = N'M:\sql_bak\At_full2.bak', DISK = N'L:\sql_bak\At_full3.bak' WITH NOFORMAT, INIT, NAME = N'At-Full Database Backup', SKIP,…
Anandita Sharma
  • 405
  • 1
  • 3
  • 9
0
votes
1 answer

sp_send_dbmail fails in SQL Server Agent Job

Could someone explain and resolve the following issue. Thanks. I encountered this query issue when I run it in SQL Server 2012 on Windows Server 2012. The query (@query) runs very well when it stands alone, but it shows no result when placed into a…
HoangDo
  • 1
0
votes
1 answer

SQL Server - send email task on job failure

we have a job that runs several times a day making incremental backups. We have added a step 'Send email on Job failure' that uses T-SQL to send an email to the admins team if the first step (Incremental backup) has failed. Unfortunately we must…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
0
votes
1 answer

email notifications from SQL Server job

We want to set a profile in Database Mail on SQL Server 2008 R2 for all the developers in our team to receive notifications once an overnight job has completed. Unfortunately, in the Notifications properties in the job it only allows us to select…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
0
votes
1 answer

SQL Job: How to start with?

Can anyone help me to create an SQL job in SQL server Agent (SQL 2008) ,which will run in a purticular time interval(Ex: Daily) and select records from a table with status=1 (select name,age from student)and pass to another stored procedure which…
Shyju
  • 214,206
  • 104
  • 411
  • 497
0
votes
2 answers

Windows Scheduler OR SQL Server Job for sending out digest e-mails

Will be sending out e-mails from an application on a scheduled basis. I have an EmailController in my ASP.NET MVC application with action methods, one for each kind of notification/e-mail, that will need to be called at different times during the…
wgpubs
  • 8,131
  • 15
  • 62
  • 109
0
votes
1 answer

SQL Server Job Dependency

I have a job in SQL Server 2000 which runs every night and refreshes the data, I have another job which runs after the data refreshes and update some records. Both of these jobs are not connected to each other. I need to know how can I stop or…
user2162617
  • 1
  • 1
0
votes
1 answer

How to automatically export SQL Server Job logs when it finish

I created a SQL Server 2008 Job when runs everyday at a specific time. When the job finishes, I can manually Export the job log as shown in the link…
Pawan Pillai
  • 1,955
  • 5
  • 37
  • 64
-1
votes
0 answers

How to Schedule a Job in sql server between two days

How To schedule a job in SQL Server that starts on Wednesday afternoon and it should end on thursday eod and between this the ssis package should execute for every one hour if any error occurs in first hour then it should automatically pick in next…
Charan G
  • 1
1 2 3
4