Which User will be invoking SQL Server Agent Job when using a Windows Task Scheduler to automate the Job to run daily?
I am using SQL Server 2008 to create a job to calculate some values from an external db and store to another db table. A task scheduler has been created for automating this to run daily and update results to the 2nd table. The job is getting failed with SQL message ID 3621 and severity 14. I googled this message id and got to know that it is due to insufficient privileges for the user.
By default which user will be invoking the SQL job by the task scheduler?
Solution
If you open the Task properties, you can see what account it is running as:
- Designing databases and applications for hosted / cloud solutions
- How do I use SQLAlchemy create_engine() with password that includes an @
- How can I check whether a number is contained in comma separated list stored in a varchar column?
- SQL Server : Always Encrypted (Datatype clash error whe trying to insert value in an encrypted column)
- Including a distribution database in 'DatabaseBackup - USER_DATABASES - DIFF' in Ola Hallengren Script
- How do I set timezone for my docker container?
- Retrieve from 4 SQL tables with two count/group by values?
- How to SELECT year using a WHERE clause on a DateTime type column
- The data type is DT_NTEXT, which is not supported with ANSI files
- Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
- Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
- How to obtain only rows with a nvarchar column containing at least one of a list of string?
- SQL Server export to Excel with OPENROWSET
- Update a date field in selected records with a calculated, relative date
- Remote certificate rejected when connecting to SQL Server from Linux host
- How to check which query or user caused SQL Server 100% CPU Utilization
- ER diagram to SQL query
- How can I correct the correlation names on this sql join?
- Query to find all members of multi level many to many relationships and also the top most member of the hierarchy
- What do the Categories in SQL Server Agent Jobs mean?
- Delphi TADOQuery exec for SQL Server stored procedure - exception not caught when multi-column unique index violated
- Get value from first row to another based on different primary key values
- Using the WITH clause in an INSERT statement
- T-SQL query very slow when using index on Date column
- Select Case Conversion failed when converting the varchar value to data type int
- Can't log into SQL server after changing computer name
- Query that groups rows based on the difference between datetime column value from a previous row?
- Add new property to nested object in all objects of JSON array with SQL
- Azure Devops SSIS Deploy, cannot connect to on prem server
- What is SQL Azure?