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
3 answers

Can't run SQL query via SQL job

I have a query which looks something like this: select tb1.col1, tb1.col2, tb2.col4, tb2.col7 from server_1.database_a.dbo.table_1 tbl1 inner join server_2.database_c.dbo.table_2 tbl2 on tbl1.col_id = tbl2.col_id This query runs fine (I had to…
oshirowanen
  • 15,297
  • 82
  • 198
  • 350
0
votes
1 answer

set sql agent job schedule time in C#

I want to schedule a group of queries run weekly/configurable.I found below code by googling but am trying to set sheduler timings for weekly execution now.Also i want it to be configurable. Am pretty new to this so somw help would be appreciated! …
Murali Uppangala
  • 884
  • 6
  • 22
  • 49
0
votes
1 answer

Visual Studio error - Exception from HRESULT: 0x800A03EC

I have an .exe that we are trying to run automatically. The application, searches a couple databases, and extract some info, then places them into an excel file, which it then drops on the server and then emails. The app was made in VS 2010. When…
Eric
  • 135
  • 2
  • 2
  • 11
0
votes
1 answer

Get Trigger times for SQL Jobs from MSDB

I have a to make a document on all the SQL Jobs in out DB servers with the trigger times, is there a way of getting all the trigger times from msdb, without going to every job under SQL server agent and checking the properties. Thanks
CSharped
  • 1,247
  • 4
  • 20
  • 49
0
votes
0 answers

saving data from an online table/CSV to sql database

I am looking into creating an sql database that extracts data from a web page. The webpage displays the data in either a table or CSV list. The address of the page is Online table/CSV I am not entirely sure how to do this. I thought maybe to…
Silentbob
  • 2,805
  • 7
  • 38
  • 70
0
votes
3 answers

using sp_send_dbmail with join

I am trying to run the following as a job on Sql Server Agent and I don't get an email. I think there is something wrong with the way I am representing tables in the inner join because if I replace the query with a simple query without joins, the…
CodeNinja
  • 3,188
  • 19
  • 69
  • 112
0
votes
1 answer

SQL Job reverts run as identity to SQL Server Agent Service Account

I've found a SQL Job(s) on a server which run an SSIS package, I've changed the 'run as' drop down to a proxy account which has permissions to run the package. I will change it to my proxy account, run it a few times. However, when I come back to…
jjamesjohnson
  • 639
  • 1
  • 7
  • 11
0
votes
2 answers

SQL Server 2008 R2 JOB Step Linked Server Login Failed

I need to transfer a table daily. Table name is changing every day, so i should use script to get the tableName. There is a job step which transfers data from sourceTable to destinationTable created by using T-SQL query. sourceTable and…
Ismail Yavuz
  • 6,727
  • 6
  • 29
  • 50
0
votes
1 answer

Permissions for PSExec run from SQL job

I have the following in a CMDExec type SQL Job step (details changed): D:\path\PSExec.exe \\servername -accepteula -u "domain\username" -p password D:\path\executable.exe This works fine. However, I have set up a proxy in SQL Server for the same…
CompanyDroneFromSector7G
  • 4,291
  • 13
  • 54
  • 97
0
votes
2 answers

Package working in visual studio but not in Job agent

I have moved my packages to another server. Now on that server when I am executing my packages on visual studio then it is working fine. But when I am deploying the same package and try to execute it both via integration services engine or SQL Job..…
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
0
votes
1 answer

Postgresql pgagent run a job from another job

I have 4 jobs in pgagent that I would like to execute in a specific order from one master job. How can I do that?
CoolStraw
  • 5,282
  • 8
  • 42
  • 64
-1
votes
1 answer

Run Sql Job in The first day of every shamsi month (persian date)

I want to run a SQL Server Agent job every first day of shamsi (persian) month.
alinn
  • 83
  • 8
-1
votes
1 answer

SQL job agent SSIS package configuration

I have an SSIS package deployed to sql server, running on a scheduled job. In the job properties Steps, I go to the Configuration tab and see my Parameters: The UploadFTPSSHKey variable is giving me problems. With the particular library I'm…
drowned
  • 530
  • 1
  • 12
  • 31
-1
votes
2 answers

How to SELECT * into a SQL table incremntally by date?

I have a SQL Server table called "tblProducts". Sometimes I backup this table by making a copy of it with this simple query: SELECT * INTO [test01].[dbo].[tblProducts_20141206] FROM [test01].[dbo].[tblProducts] Every time when making a backup, the…
user3486647
  • 191
  • 1
  • 4
  • 12
-1
votes
1 answer

Cannot index into a null array error when value is not null

I am using Poweshell to view the status of specific SQL job. I want to pass job name as input like read-host or pass through variable. The script works fine when job name is static string in qoutes(Script 1) .In case I pass it through variable, it…
anupinder
  • 11
  • 1
  • 1
  • 5
1 2 3
…
18
19